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 4007

explain unit testing,systemtesting,integrated testing

CSC,

1 6925

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 5999

how many session run unix environment what command using ?

HCL,

1 7220

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 9676

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 9098

What is degenerated dimention table?

Patni,

7 10551

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 12181

what are the unix commands to start the wrk flow ?

Accenture, TCS,

4 12517

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

Icon,

5 18607

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 8412

What is junk dimention?

Patni,

3 8040

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 9096

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

4 12382

Un-Answered Questions { Data Warehouse }

what is online view?

1937

Which algorithm you used for your hashfile?

1181

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1955

How we check the errors before running the report?

998

What are the different forms of output that can be obtained after processing of data?

1256

AWS Redshift is basically works on nodes and cluster and which of following option Redshift is based on?

what is guided navigation?

898

What are the key columns in Fact and dimension tables?

980

what is Forward,Reverse and Re_engineering?

2194

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9819

What is the difference between SAS functions and procedures?

1152

what is hash files in sas and why we are using this one in sas?

2217

What is enterprise data warehousing?

1047

Difference between cold fusion 5 and cold fusion mx 6?

993

What is the good sas programming practices for processing large data sets?

1114

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