Answer Posted / rahul
JOINER T/R
SORTER T/R
AGGREAGATOR T/R
RANK T/R
LOOKUP T/R
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is joiner transformation in informatica?
Define enterprise data warehousing?
In informatics server which files are created during the session rums?
hi real timers . iam waiting for ur reply regarding ETL TESTING
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?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Is stop and abort are same in informatica?
What is persistent lookup cache?
Explain your project of banking domian.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is flashback table ? Advance thanks
How do you load alternate records into different tables through mapping flow?
What are the differences between oltp and olap?
Explian the Process of deployment groups in informatica
