Data Warehouse Interview Questions

How can we eliminate duplicate rows from flat file?
How do you create a mapping using multiple lookup transformation?
what is the look up transformation?
What is mystery dimention?
What are various types of Aggregation?
What is a view? How it is related to data independence?And what are the different types of views,and what is Materialize view views
Can you start a session inside a batch idividually?
In a sequential Batch how can we stop single session?
How to load time dimension?
What are variable ports and list two situations when they can be used?
What are the joiner caches?
How the informatica server sorts the string values in Ranktransformation?
In which circumstances that informatica server creates Reject files?
How the informatica server sorts the string values in Ranktransformation?
Explain about perform recovery?
What is exact use of ‘Online’ and ‘Offline’ server connect Options while defining Work flow in Work flow monitor?
If you are workflow is running slow in informatica. Where do you start trouble shooting and what are the steps you follow?
What is incremantal aggregation?
What is source qualifier transformation?
What is a source qualifier?-
What is source qualifier transformation?
Why you use repository connectivity?
What is aggregate cache in aggregator transforamtion?
What is parameter file?
How do you handle decimal places while importing a flatfile into informatica?
How do you handle decimal places while importing a flatfile into informatica?
Describe two levels in which update strategy transformation sets?
How can we join the tables if the tables have no primary and forien key relation and no matchig port to join?
How do you create single lookup transformation using multiple tables?
What is tracing level?

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>