What is a surrogate key?
No Answer is Posted For this Question
Be the First to Post Answer
How to recover the standalone session?
What is the difference between informatics 7x and 8x and what is latest version?
Mention few advantages of router transformation over filter transformation.
What is dimensional table? Explain the different dimensions.
Differentiate between Load Manager and DTM?
How do you recover rows from a failed session
What is the procedure for creating independent data marts from informatica 7.1?
What is the sql query overwrite in source qualifier in informatica
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
Could you explain what is enterprise data warehouse?
How to load last n records of file into target table - informatica