How can you define a transformation? What are different types of transformations in Informatica?
TCS,
7 11076Post New Data Warehouse General Questions
How to generate the cubes in framework manager?
What is mean by aggregate aware?
Describe a data warehouse.
Explain difference between snow flake and star schema.
What is cubes?
How do you create surrogate key using ab initio?
what are relationships?
What are the key columns in Fact and dimension tables?
Explain the data type of the surrogate key?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
Explain where do we use semi and non additive facts?
Is union transormation is active transformation?
What is dimension modeling?
Explain the definition of normalized and denormalized view and what are the differences between them?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?