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

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  


WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  


how many ways can we implement SCD2?

4 Answers   IBM, TCS,


Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,


How do we call shell scripts from informatica?

0 Answers  






write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,


How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,


draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,


If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  


what is update strategy transformation ?

7 Answers   TCS,


How can we update a record in the target table without using update strategy?

0 Answers  


i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,


Categories