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 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  


Explain pmcmd command usage in informatica

0 Answers   Informatica,


what are factless facts? And in which scenario will you use such kinds of fact tables.

0 Answers  


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

0 Answers  


How can we use mapping variables in informatica? Where do we use them?

0 Answers  






How can repository reports be accessed without sql or other transformations?

0 Answers  


Explain the code page compatibility?

0 Answers  


Whats the difference between $, $$, $$$

9 Answers  


explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

1 Answers   TCS,


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,


what is the drillup & drill down?and use of the drill up and drill down?

1 Answers   IBM,


Categories