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

Enterprise data warehouse your projects phase by phase explain?

1972

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

ABC, Cap Gemini,

4 10334

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

Logica CMG,

3 11284

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

Logica CMG,

3 8504

How to add source flat file header into target file?

Logica CMG,

3 9355

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

TCS,

8265

Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

7 10825

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix.

DELL,

1 8037

where we cannot use sorter Transformation. if we use then we will not get correct data?

2253

Does Facttable Normalized or Denormalized?

IBM,

2 8265

Any body help me...what are challenges did u face in Business object project?

1 4969

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

Cap Gemini,

7 12879

we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

1 5557

we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??

4 8800

Informatica and datawarehousing courses in Pune?

2 5522

Un-Answered Questions { Data Warehouse }

Explain what are the steps to build the data warehouse?

1000

What is meant by lookup transformation? Explain the types of lookup transformation?

1022

what do the pad and dim functions do? : Sas programming

1078

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2445

Where can we find the throughput option in informatica?

1113

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4152

Explain how abinitio eme is segregated?

1566

What are all difference between business objects 6.5 and xi r2?

1097

How to create a permanent sas data set?

1314

How is MLOAD Client System restarted after execution?

1207

Highlight the need for Performance Tuning.

1157

Explain is there any default username & pwd for bo designer & supervisor?

1063

What is smp and mpp platforms?

1037

What is Data Caches size?

1130

What are data validation strategies for data mart validation after loading process?

1062

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