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 lookup table in etl testing?

1138

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1333

1057

What is the maximum and minimum length of macro variable

1195

Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

1043

Can someone tell me the behaviour of next_in_sequence() and innovation_number() in a multifile. Suppose I have records 1,1,1,2,2,3,4,4 in a 4ways mfs file. Data in each partition is: 0th : 1,1,1 1st : 2,2 3rd : 3 4th : 4,4 What will be the sequence of these records if I pass next_in_sequence() and innovation_number() ? Also how can I extract 3rd record from each of the 4 partitions of a 4way multifile through AbInitio? In unix we can use m_dump

1 4775

Can some tell me at which level pdl gets resolved when parameters are resolved in abinitio? Also what happens in dml evaluation during parameter evaluation ?

1324

Whenever we load data into oracle table from staging table using exchange partition...then I read somewhere that data actually doesn't move in this and this command only reset the pointer in the data dictionary...so if data doesn't move then how data is loaded into the main table ? I mean wat is the point of pointer update in data dictionary?

974

What is the return type of lookup_not_loaded() ? Does it return 0 or 1 to signify true or false or does it return index ...can someone please explain.

1346

How can we increase the loading performance of oracle table in AbInitio?

1108

What happens when we provide null key to sort, merge and pbks in Abinitio ?

1620

Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

1440

Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio

1686

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

978

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

994

Un-Answered Questions { Data Warehouse }

what is the difference between cubes and package in cognos

4913

How can I schedule reports in cognos?

974

what is requery in cognos?

2461

What is the difference between proportion and average?

3292

What is the Process to creating lookup transformation in informatica

1003

How would you join a node to the already existing domain?

1089

What are the types of lookup transformation?

1036

Explain what is the difference between stop and abort?

999

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1221

What is MPP in Redshift ?

Nls stands for what in datastage?

1156

what is index?how it can work in informatica

2001

Describe the impact of several join conditions and join order in a joiner transformation?

1025

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1740

What is fact extension?

1050

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