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 to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.

1 4010

explain unit testing,systemtesting,integrated testing

CSC,

1 6929

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

Patni,

2 6005

how many session run unix environment what command using ?

HCL,

1 7222

follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000

IBM,

5 9681

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

Wipro,

5 9101

What is degenerated dimention table?

Patni,

7 10561

You have a data set of 100 observations,how can you restrict the output so that the output has only data from row no. 10 to row no. 20

9 12186

what are the unix commands to start the wrk flow ?

Accenture, TCS,

4 12532

what is prime numbers? how we can get plc write sas code?

Icon,

5 18611

how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this

HCL,

5 15185

how many stages are there in Datastage... Please clarify mee??

3 8414

What is junk dimention?

Patni,

3 8041

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

Patni,

4 9099

How to create a completed dashboards in cognos report studio? and how to change the bar colours for differencet columns in bar charts?

4 12383

Un-Answered Questions { Data Warehouse }

What is a rollup component?

1137

how do u set partition points in the mapping?

2239

What is the advantages data mining over traditional approaches?

967

What is the purpose of having stored procedures in a data-based?

1100

What is the function of look up transformation?

1123

Explain object variable error?

1002

If informatica has its scheduler why using third party scheduler?

1268

How many components in your most complicated graph?

1299

How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

953

What is a bo repository?

1045

What is deployment group?

1215

Difference between sequential file and data set?

1205

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2109

Explain what is sandbox?

1089

What is grain of fact?

982

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