1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?

 1 794

What is Local Cache and how does it help in performance tuning

 1 778

How do you improve the performance of the Cognos Analytics report

 528

What will be the output of using partition by Round-Robin after the partiton by key in ab initio?

 1 1233

What will be the skew for, input file->partition by key-> partition by round robin->output file

 414

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

 530

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

 355

what is the output when -1 is put in select_expr of FBE?

 936

How to replace last 4 digits of an input column with XXXX given input column has 12 digits?

 607

Code check-in and check-out commands in AbInitio

 3351

Given input file with single column having 1 2 2 4 3 .. Required output 1 2 2 4 4 4 4 3 3 3.. How?

 531

How to process records in batches like 1-20 records in first execution and 21-40 records in second run.. so on

 467

How to convert a single column values 1 2 3 4 to single row of 4 columns ? And vice-versa

 644

Runtime behavior of Normalize and Reformat

 1708

What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.

 514

Un-Answered Questions { Data Warehouse }

What are the types of containers in datastage?

697

What do you mean by staging area?

516

EXL informatica Questions

924

Enlist the tasks for which source qualifier transformation is used.

581

What is the difference between absolute filtering and standard filtering?

513




What is the size of database for you project?

1103

what is the difference between native sql and cognos sql?

505

Define Routines and their types?

616

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1115

What are routines in datastage? Enlist various types of routines.

619

Differentiate between datastage and datastage tx?

586

What are your responsibilities as an etl tester?

615

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1692

can cubes contain measures ?

1638

what are _numeric_ and _character_ and what do they do? : Sas programming

667

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