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

Why we require dwh in particular projects?

1 5238

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

Amdocs,

3 17752

What is the difference between warehouse key and surrogate key?

Accenture,

1 6764

hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

Cognizant,

2125

what is AE onset date and what is RDS?

Accenture,

4 10228

I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

IBM,

3 7347

SOURCE LIKE I_D,F1,F2 --------- 100,N,Y 100,N,N 100,Y,N 101,Y,Y 101,N,Y 102,Y,N 103,N,N 104,Y,Y 105,N,N 106,N,Y 102,N,Y 105,Y,Y O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 7276

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 5630

how to rearrange the data as our wish by using dataset block?

Cognizant,

4 8801

how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2764

what are the limitation of sorter transformation?

TCS,

2 12899

what is Materialized Views?

Syntel,

2 7477

can we load 10 millions of records into target table by using tpump?

HP,

1 5659

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2696

where we can use the delimiter in mload? pls let me know

Wipro,

2 9216

Un-Answered Questions { Data Warehouse }

What all is needed to achieve an crystal report? A crystal report server ,User Id .Is BI/BO needed.Our source is Microsoft SQL Server 2008 Datacenter.Please guide.

2606

How to handle multi value dimensions?

2297

What is the status code in stored procedure transformation?

1185

How to find value from a column in a dataset?

2207

Explain what is the metadata extension?

1044

Describe the evaluation of parameters order in ab initio?

1534

what are the all possible features supported modify stage?

2146

what is the cube size?

Can informatica load heterogeneous targets from heterogeneous sources?

1188

Differentiate between datastage and datastage tx?

1059

What do you mean by static prompt report?

989

what is the limit of string length in turbo integrator?

what is the difference between querystudio in reportnet and cognos8

2138

Explain the difference between data ware house & data mart?

963

Explain the purpose of substr functions in sas programming.

1065

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