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 24372

Pls tell me what is troubleshooting in datastage view?

1 8167

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 15236

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

1873

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

2174

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 10974

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 6423

what is the significance of newlookup port in dynamic look up

IBM,

1 6336

how many ways can we implement SCD2?

IBM, TCS,

4 15834

How many joins in Informatica

CSC,

5 24046

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

CSC,

3 9484

What is router transformation

CSC,

4 7127

How to eliminate duplicates in FF and oracle both

CSC,

3 7269

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

CSC,

2 7349

How can we use consolidations in microstrategy report

IBM, Wells Fargo,

4 18348

Un-Answered Questions { Data Warehouse }

Did you face any problems while creating reports? Name? Solutions?

3692

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1165

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1507

What are the uses of etl tools?

1128

What is union transformation?

965

How does microstrategy object manager determine if two projects are related?

1053

Is stop and abort are same in informatica?

1002

How do you verify a complicated sql?

1067

What are vldb properties in microstrategy?

1044

What is model?

969

What is Star Schema?

1109

Which development components of informatica have the highest usage?

1043

How to allow a dynamic selection of a column for a measure in a chart,without using variable?

994

Explain some of modeling tools available in the market?

968

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2970

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