About Us

 Welcome to visit in mynotemytechnology page:

The bloges are create to know about the interview question related to SQL server and Informatica Power Center and Informatica Cloud Data Integration.


There are given some tips about the computer and some basis content about the SQL server and Informatica Power Center and IICS.


Please go through the all the content as per your requriement and visit the contact us page to reach out to me.


Thank you
Users

Comments

Post a Comment

Popular Post

SQL Server Database Interview Questions and Answers

SQL Server Database Interview Questions and Answers 1) You have two columns in source table in which the col1 may contain duplicate values, All the duplicate values in col2 will be transformed as comma separated in the column col2 of target table Answer :  --Select Query in table Query : select * from tbl1  col1 col2 a x     b y     c z     a m     b n     Solution : Select col1, STRING_AGG(col2,',') Result  from tbl1  group  by col1  --OR  select col1, STRING_AGG (col2,',') WITHIN GROUP (ORDER BY col2 ) Result  from tbl1 group by col1  Output : col1 Result a x    ,m     b n    ,y     c z     2) Reading a source file with salary prefix $, in the target the Sal column must store in number . Answer: select * from source; empno ename job managerid firedat...
Read more

SQL Server Database Details

SQL Query Execution flow:- The phases involved in the logical processing of an SQL query are as follows: FROM clause ON clause OUTER clause WHERE clause GROUP BY clause HAVING clause SELECT clause DISTINCT clause ORDER BY clause TOP clause
Read more