What is degenerate dimension table?
No Answer is Posted For this Question
Be the First to Post Answer
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is crass reference table?
What is conformed fact?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
What are Fact tables and Dimension Tables?
What is surrogate key? Explain with examples.
How much data hold in one universe.
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
What is difference between Mapplet and reusable transformation?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
Suppose we want to display zero when null values coming to report how can we do that?
Explain what are the vaious etl tools in the market?