diff b/w dwh & data mart
diff b/w star schema & snow flake schema
diff b/w fact table & dimension table
what are the contents in requirement specification
what are the docs needed for testing
draw ur proj architecture
No Answer is Posted For this Question
Be the First to Post Answer
what are Lookup caches options? Including persistent caches.
explain the methodology of Data Warehousing?(Polaries)
What is factless fact schema?
Identifying the bottlenecks in various components of Informatica and resolving them.
what is architecture of your datastage project??? i came across this question many times in interviews in specific what can i answer plz help me.
Explain about hash partitioning?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how would u estimate the size of Lookup transform data and index cache?
What are the key benefits of ETL Testing?
In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.
Can we create Hierarchies in generic datasources?