Answer Posted / pradosh
this is a stupid Question,
informatica is a ETL tool which is extract,transfoemation,and load data from source to target,bcz our project based on informatica tool so we used
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Describe expression transformation?
What does role playing dimension mean?
What are the different options available for update strategy?
What are the guidelines to be followed while using union transformation?
What is the command used to run a batch?
What is an Integration service in Informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What are the performance considerations when working with aggregator transformation?
According to his methodology what all you need before you build a datawarehouse
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to differentiate between the active and passive transformations?
What is meant by pre and post session shell command?
What is session task and command task?
As union transformation gives UNION ALL output, how you will get the UNION output?