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
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.
Explain pmcmd command usage in informatica
what are factless facts? And in which scenario will you use such kinds of fact tables.
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??
How can we use mapping variables in informatica? Where do we use them?
How can repository reports be accessed without sql or other transformations?
Explain the code page compatibility?
Whats the difference between $, $$, $$$
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?
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
what is the drillup & drill down?and use of the drill up and drill down?