write a query to retrieve the latest records from the table sorted by version(scd)


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers   Emphasis,


While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  


What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,


In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,


Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  






what is diff b/t sorter t/r and agg have the option sorter property...

0 Answers  


What happens if we dont select data driven option?

2 Answers   Zensar,


what is the architecture of any Data warehousing project?

5 Answers   IBM,


can session assigned multiple mappings or not?

2 Answers   Zensar,


One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

5 Answers   HCL,


How to merge First Name & Last Name?

8 Answers  


what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  


Categories