1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

Explain the different dimensions.

 538

Differentiate between source qualifier and filter transformation?

 976

Explain scd type 3 through mapping.

 567

What is dimensional table?

 609

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

 991

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

 617

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

 619

Explain in detail about scd type 1 through mapping.

 570

Write the unconnected lookup syntax?

 644

Write the unconnected lookup syntax and how to return more than one column.

 581

How do you remove duplicate records in informatica? And how many ways are there to do it?

 693

What is dimensional table? Explain the different dimensions.

 638

What are the types of caches in lookup?

 554

What are the types of caches in lookup? Explain them.

 536

Differentiate between router and filter transformation?

 600

Un-Answered Questions { Data Warehouse }

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro

584

Is AWS redshift is one of the RDS in AWS or is it Relation Database?

5

Explain what Proc glm does?

621

Distinguish between informatica & datastage. Which one would you choose and why?

570

What is fact? What are the types of facts?

530




What is the use of powerhouse?

606

What is the use of cognos decision stream?

647

What all the types of jobs you developed?

654

Explain the importance of surrogate key in data warehousing?

698

What is a core dimension?

596

Why need staging area database for dwh?

627

Explain about core dimension, balanced dimension, and dirty dimension?

542

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

1885

Explain the difference between the truncate and delete commands?

593

What are the main steps to build the data warehouse?

643

For More Un-Answered { Data Warehouse } Questions Click Here