Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

emc2,

3 8029

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

Cognizant, emc2,

2 8307

Explain Dataware house architecture .how data flow from intial to end?

Keane India Ltd,

2595

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

emc2,

2 5322

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

IBM,

9 13380

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

Cognizant,

3 9574

can any one explain me about junk dimension

4 6708

where actually the usage of push down optimization happens...

2 5539

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

IBM,

1 4997

How many nodes supported by a one cpu in parallel jobs?

IBM,

3 10392

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 11003

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

IBM,

5 8464

differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

IBM,

2 6294

what is the need of session partitioning... how it is useful in real time

Amazon,

3 8784

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

IBM,

1 5234

Un-Answered Questions { Data Warehouse }

What are the issues you have faced in your project? How did you overcome those issues?

2381

How does a rank transform differ from aggregator transform functions max and min?

1219

What is collect statistics?

1016

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2045

What is the difference between orabulk and bcp stages?

1041

What are default access rights in teradata? What explicit right can be given to a user?

1120

What is partitioned primary index (ppi)?

1062

What is aggtorec restructure operator?

1472

what are the types in error loging?

2163

Explain the difference between data ware house & data mart?

971

Explain data flow graph with an example?

1145

what is epilog tab?

What is the main difference between inmon and kimball philosophies of data warehousing?

1126

What is informatica?

1166

how does sas handle missing values in a merge? : Sas programming

1063

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