Answer Posted / shashi
like to add a little bit.
just go to any Query editor and use DENSE rank() this will
clarify much more.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Briefly describe lookup transformation?
How might one distinguish in the case of mapping is right or not without associating session?
explain one complex mapping with logic? sales project?
What is workflow? What are the components of the workflow manager?
Explain sessions. Explain how batches are used to combine executions?
Differentiate between Load Manager and DTM?
Explain direct and indirect flat file loading (source file type) - informatica
What differs when we choose the sorted input for aggregator transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain lookup transformation is active in informatica
What is rank index in rank transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is the command used to run a batch?
How we can create indexes after completing the load process?