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

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2309

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

HP,

1981

In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

HP,

1 3191

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

IBM,

1802

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

Accenture,

1 3419

How do you join more than 3 flat files in informatica?

ITC Infotech,

1 3185

Useful UNIX commands regular/frequently used

Deloitte,

1 4496

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1776

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 2543

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1535

what is repositery?

IBM,

1850

Why the workflow is failed after running two hours in informatica?

GE,

1 2863

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1503

if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

Accenture,

1409

What's the difference between VAR A1 - A4 and VAR A1 - A4?

Quintiles,

1 4966

Un-Answered Questions { Data Warehouse }

Have you created hierarchy in obiee. If so where and how?

892

Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?

1101

what is transformation in sas data integration? : Sas-di

1038

How do you import and export the datastage jobs?

1163

Explain what is ods (operation data source)?

996

can be used COM component in Informatica ?

2065

What is informatica? Why do we need it?

1108

Explain constraint based loading in informatica

1103

can u any challenge your project?

2037

Have you used rollup component? Describe how.

1076

What are sequencers?

1124

What is the difference between static cache and dynamic cache?

998

What is a Datastore in Cognos?

1291

What is fact table? Explain the different kinds of facts.

1080

What are shortcuts? Where it can be used? What are the advantages?

1076

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