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
Why you use repository connectivity?
HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....
WHat all joins are there in Source Qualifier?
what is degenerated dimension table with scenario
What is a taget load order?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")
Explain the code page compatibility?
How can we use mapping variables in informatica? Where do we use them?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
What if the source is a flat-file?
I want skip first 5 rows to load in to target? what will be the logic at session level ??