How to join 3 database like flat file, oracle, db2 in informatrica?
No Answer is Posted For this Question
Be the First to Post Answer
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Can we have more than one time dimensions in a Schema(Star or Snowflake)
Suppose we want to display zero when null values coming to report how can we do that?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is surrogate key? Where we use it? Explain with examples.
What are the design methods of data warehousing?
What are Non-additive facts?
What is the difference between drill through and masterdetail reports?
What are various warehousing tools?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what are the various file formats involved in reportnet?
Why do we use DSS database for OLAP tools?