How to handle multi value dimensions?

Question Posted / monalidwh

No Answer is Posted For this Question
Be the First to Post Answer

More Data Warehouse General Interview Questions

How to generate the cubes in framework manager?

What is a look up function? What is default transformation for the look up function?

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

How can you define a transformation? What are different types of transformations in Informatica?

Do you view contain data?

How we are using this function?

what is the difference between aggregate table and fact table ? how do you load these two tables ?

How can we acheive correlated sub-query in designer?can anyone help me in this regard?

Explain the data type of the surrogate key?

What are the different types of scd's used in data warehousing?

Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?

What is BCP?

For more Data Warehouse General Interview Questions Click Here