Data Warehouse Interview questions Part V

data warehousing faqs
Informatica Interview Questions
What is the mapping for unit testing in Informatica, are there any other testings in Informatica, and how we will do them as a etl developer.
what is the difference between dynamic and static lookup…y and when do v use these types of lookups ( ie…dynamic and static )
How to export mappings to the production environment?
How can you recognise whether or not the newly added rows in the source are gets insert in the target?
Can anyone explain about incremental aggregation with an example?
What is the process flow of informatica,
How to define Informatica server?
Which tool U use to create and manage sessions and batches and to monitor and stop the informatica server?
Define informatica repository?
What is the default join that source qualifier provides?
What are the types of groups in Router transformation?
What is IQD file?
How do you decide whether you need ti do aggregations at database level or at Informatica level?
How do we estimate the number of partitons that a mapping really requires? Is it dependent on the machine configuration?
What is polling?
What is metadata reporter?
What happens if you try to create a shortcut to a non-shared folder?
What is the use of incremental aggregation? Explain me in brief with an example.
How to join two tables without using the Joiner Transformation.
What are the tasks that source qualifier performs?
What r the tasks that source qualifier performs?
In a joiner trasformation, you should specify the source with fewer rows as the master source. Why?
What is meant by Junk Attribute in Informatica?
What are two types of processes that informatica runs the session?
What r the tasks that Loadmanger process will do?
What are the tasks that Loadmanger process will do?
What are the mapping paramaters and maping variables?
What is difference between maplet and reusable transformation?

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>