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

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

Accenture,

6 14874

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

TCS,

6 11828

what is the diff b/w cached and unchaed look ups

IBM, TCS, Wipro,

3 7871

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 9083

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 5495

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

Syntel,

2 12778

How to remove duplicates in transformer stage? in parallel mode

Syntel, TCS,

6 17448

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

Syntel,

4 15354

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 11063

how to delete one row in target dataset

Satyam,

3122

if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!

IBM,

8 29464

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

IBM,

1 6280

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3373

i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.

Emirates, IBM,

10 15317

is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)

2 7236

Un-Answered Questions { Data Warehouse }

What is source qualifier transformation in informatica?

1011

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2420

What is the difference between mapping parameter & mapping variable in data warehousing?

986

Define Dynamic push down optmization?

2300

Differentiate between operational datastage (ods) and data warehouse?

1178

can we insert all types of charts in a list report? what r the realtime prompts?

2212

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866

What are the two types of framework manager?

1336

what are all the reports you generated in your recent project?

2199

What are the ways in which macro variables can be created in sas programming?

1103

What are non-additive facts in detail?

995

Can you explain tagbatch restructure operator?

1177

What is a hash cluster?

983

What are different types of transformations available in informatica?

991

What is purpose of having conditionality in metrics in microstrategy?

978

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