Answer Posted / rr
Star schema has denormalised dimension tables connected to
a single fact table.
Snow flake schema has normalised dimension tables.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How can a transformation be made reusable?
What do think which one is the better joiner or look up?
What do you mean by blocking transformation?
What are the issues you have faced in your project? How did you overcome those issues?
Explain the code page compatibility?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What are the measure objects?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is workflow monitor?
Explian the Process of deployment groups in informatica
EXL informatica Questions
What is union transformation in informatica?
What is a filter transformation and why it is an active one?
How to load last n records of file into target table - informatica
Explain in detail about scd type 1 through mapping.