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?

1921

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 10167

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

Logica CMG,

3 11111

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

Logica CMG,

3 8367

How to add source flat file header into target file?

Logica CMG,

3 9188

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

TCS,

8201

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 10591

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 7940

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

2199

Does Facttable Normalized or Denormalized?

IBM,

2 8150

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

1 4883

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 12633

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 5457

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 8649

Informatica and datawarehousing courses in Pune?

2 5411

Un-Answered Questions { Data Warehouse }

Explain scan md?

1078

What is a dimension?

1031

what is study design in while working with SAS? what are screening variables in SAS?

2242

What is the difference between hashfile and sequential file?

1258

How to restrict password to a user while sending a document in .pdf format

2342

What are the primary keys and foreign keys?

1142

Does an informatica transformation support only aggregate expressions?

1042

What is the difference between account and directory options ?

1182

Explain teradata architecture?

1091

What is substr function?

1188

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2146

What is model?

967

can we override a native sql query within informatica? Where do we do it?

1122

What is the use of cognos decision stream?

1091

Explain and compare etl & manual development?

925

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