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 is the version control how can i apply this in DataStage can any one tell me the anser

IBM,

4 24395

Pls tell me what is troubleshooting in datastage view?

1 8181

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

CTS, TCS,

5 15268

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1881

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2194

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

Wipro,

5 11011

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

Wipro,

2 6440

what is the significance of newlookup port in dynamic look up

IBM,

1 6350

how many ways can we implement SCD2?

IBM, TCS,

4 15859

How many joins in Informatica

CSC,

5 24081

How to identify this row for insert and this row for update in dynamic lookup cache

CSC,

3 9504

What is router transformation

CSC,

4 7157

How to eliminate duplicates in FF and oracle both

CSC,

3 7294

If I am having 6 flat files in data. How can you load the data at a time

CSC,

2 7371

How can we use consolidations in microstrategy report

IBM, Wells Fargo,

4 18381

Un-Answered Questions { Data Warehouse }

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

2167

How do you set the session mode parameters in bteq?

1116

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2078

How conflicts occur and what are the ways to resolve them?

972

What do you mean by tpt in teradata?

1030

What are the Graph parameter?

1169

Define catalog in cognos and write its various types?

1194

How would you find out whether a sql query is using the indices you expect?

1085

What are types of transport files?

8023

What are different types of metrics in microstrategy?

971

explain what is factor analysis? : Sas-administrator

1123

Under which circumstances, informatica server creates reject files?

1109

If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1035

What is the use of the %include statement?

1179

4 yrs etl devloper roles and responsibilities?any body give solutions

2182

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