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 24624

Pls tell me what is troubleshooting in datastage view?

1 8274

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 15544

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

1 1951

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

1 2279

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 11230

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 6578

what is the significance of newlookup port in dynamic look up

IBM,

1 6488

how many ways can we implement SCD2?

IBM, TCS,

4 16057

How many joins in Informatica

CSC,

5 24273

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

CSC,

3 9662

What is router transformation

CSC,

4 7357

How to eliminate duplicates in FF and oracle both

CSC,

3 7446

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

CSC,

2 7478

How can we use consolidations in microstrategy report

IBM, Wells Fargo,

4 18612

Un-Answered Questions { Data Warehouse }

Have you have ever worked in unix environment and why it is useful in datastage?

1215

What is dimensional table? Explain the different dimensions.

1269

How to add default rules in transformer?

1284

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2150

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2421

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1202

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2767

How would you format some text using css to be verdana and bold?

1150

Write the unconnected lookup syntax and how to return more than one column.

1174

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3442

Explain scd type 3 through mapping.

1074

Demonstrate experience in maintaining quality process standards?

2672

faq's on cognos

4112

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2176

what is document design in boxi,have u participate in that

2306

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