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 795

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

 1 780

How do you improve the performance of the Cognos Analytics report

 530

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

 1 1234

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

 415

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

 532

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?

 608

Code check-in and check-out commands in AbInitio

 3353

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?

 532

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

 468

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

 1709

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.

 515

Un-Answered Questions { Data Warehouse }

What are multi-group transformations?

556

What are the components of report net?

724

i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

1612

What are the different versions of sas that you have used until now? : sas-grid-administration

721

how to delete one row in target dataset

2582




how to perform single sign in cognos by using url?

562

What are the different kinds of panes included in cognos?

581

Name the types of transformation?

525

What is native users?

714

Explain what is the use of proc gplot?

695

What is prompt types of prompts?use of prompts syntax of prompt?

657

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2424

Explain pushdown optimization $pushdownconfig parameter - informatica

695

What is de-partition in abinitio?

877

What is the difference between set functions and filter function in dimensional data?

2508

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