What is a relationship?

566

How to pivot data using informatica when you have variable amount of pivot rows?

509

Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

566

What is vldb(very large databases)?

536

Explain why dimenstion tables are denormalized in nature?

507

Suppose we want to display zero when null values coming to report how can we do that?

520

After the generation of a report to whom we have to deploy or what we do after the completion of a report?

499

What is the difference between olap and oltp?

550

Explain the difference between data ware house & data mart?

542

Explain what is a cube in data warehousing concept?

545

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

510

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 347 what is hybrid slowly changing dimension?

534

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

584

Explain what are conformed dimensions?

562

Why is chameleon method used in data warehouse?

684