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?

2305

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,

1975

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 3180

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

IBM,

1795

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 3412

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

ITC Infotech,

1 3178

Useful UNIX commands regular/frequently used

Deloitte,

1 4493

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 2537

(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.

1526

what is repositery?

IBM,

1843

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

GE,

1 2850

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?

1500

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,

1404

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

Quintiles,

1 4959

Un-Answered Questions { Data Warehouse }

What are the different options associated with dsjob command?

1436

Difference between informatica vs ab initio?

1309

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

1149

Describe the ways in which you can create macro variables?

1193

How will you move hashed file from one location to another location?

2151

How can we run the graph? What is the procedure for that?

945

What is the function of model design accelerator?

952

Explain direct and indirect flat file loading (source file type) - informatica

1318

Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1259

What is an aggregator transformation?

1096

What are the steps required to kill the job in Datastage?

1218

What are the newly developed features of Teradata?

1031

can be used COM component in Informatica ?

2059

how do you want missing values handled? : Sas programming

958

What is a node in teradata?

997

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