Answer Posted / padmavathi
Joiner:
Can join herterogeneous sources.
Can join non-relational sources.
Can join partially transformed data.
Loopup:
Can reuse cache across session run.
Can reuse cache with mapping.
Can modify cache dynamically
Can query relational table or flat file.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
what is song in infrmatica...?
What is dynamic cache?
Differences between version 7.x and 8.x.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the issues you have faced in your project? How did you overcome those issues?
How do you remove duplicate records in informatica? And how many ways are there to do it?
can u any challenge your project?
What is the format of informatica objects in a repository?
r u done any partitions in ur project?
Explain the use of aggregator cache file?
What do you mean by filter transformation?
What is the sequence generator transformation in informatica?
What is an expression transformation in informatica?
Explain the difference between a data warehouse and a data mart?