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 793

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

 1 775

How do you improve the performance of the Cognos Analytics report

 526

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

 1 1230

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

 413

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

 528

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

 353

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

 930

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

 606

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?

 529

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

 464

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

 1707

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.

 511

Un-Answered Questions { Data Warehouse }

How to use pmcmd utility command?

574

how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

1621

How can we store previous session logs?

557

Can you define a catalog and types of catalogs in cognos?

568

Can you explain the advantage of using shortcuts?

605




What Proc glm does?

599

Explain is there any other repository domains rather than universe, security, document?

576

What is conduct>it?

626

What is your spectra photometer working principles?

552

What is model filter?

620

What is metadata in microstrategy?

613

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1545

What you know about transaction control transformation?

548

What are data modeling and data mining?

645

Give some difference between oltp and olap.

589

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