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 4107

explain unit testing,systemtesting,integrated testing

CSC,

1 7013

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 6117

how many session run unix environment what command using ?

HCL,

1 7354

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 9900

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 9303

What is degenerated dimention table?

Patni,

7 10883

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 12543

what are the unix commands to start the wrk flow ?

Accenture, TCS,

4 12731

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

Icon,

5 18827

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

HCL,

5 15446

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

3 8560

What is junk dimention?

Patni,

3 8248

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 9310

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

4 12600

Un-Answered Questions { Data Warehouse }

How to use procedural logic inside infromatica?

1342

What is the report studio?

1078

How to extract sap data using informatica?

1102

Mention sas system options to debug sas macros.

1249

Explain the meaning of Amp?

1257

What are steps we have to follow in designing the userfriendly universe?

1021

How sas treats the dsd delimiters?

1276

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202

To what type of programms have you used scratch macros?

2616

What is a deadlock and how it occurs?

1210

How do you create surrogate key using ab initio?

1060

AE datasets names? how many types?

2563

What is data analytics in simple terms?

1278

what are the types in error loging?

2211

Why null values are mapped as 0 in fact tables?

1056

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