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

How to use Environment variable's in datastage?(use of process)

1 7723

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 7165

what is the difference between Ranking and sort-out in bo?

iNautix, TCS,

2 14950

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

TCS,

2290

what are the different ways of merging two datasets.name atleast 4.

2 6112

How many types of models are present in cognos.?

4 11195

what is the use of surogate key in datastage

TCS,

2332

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 9013

what is the use of surogate key in datastage

3 9500

Plz can any one say me how to get the informatica certification materials and dumps

TCS,

2059

why normalizer transformation can not used in mapplet? plzzzz answer

Syntel,

2 15221

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

IBM,

2 6935

what is stitched query???

IBM,

2 6361

what is Galaxy schema??

IBM, iGate, Wipro,

2 8845

when we have to go for a sequential file stage & for a dataset in datastage?

1 5146

Un-Answered Questions { Data Warehouse }

what is log in cognos?

1214

Which commands are used to import and export the datastage jobs?

1426

What is meant by pre and post session shell command?

1170

What do you understand by the cognos?

990

What are the tasks that can be performed using sq?

1107

How are the dimension tables designed?

1015

in oracle target stage when we use load option and when we use upsert option?

2293

Define Data Stage?

1104

What is the difference between connected and unconnected stored procedures?

1096

Explain vproc in teradata?

1015

Why is business intelligence (bi) important in data warehousing?

954

Explain the tuning lookup transformation - informatica

1005

How do you do backup and recovery in teradata?

1037

How do you determine the number of sessions?

1075

What is the importance of the exception activity in datastage?

1082

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