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 a candidate key?

7 15926

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

Accenture, VAMA,

5 10644

Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.

TCS,

4 7349

Which is the best training institute for SAS in Delhi. Please reply

HCL, HSBC,

12 26356

In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 6946

How can i set break points in debugging mode ? can explain steps please?

ABC, TCS,

1 14452

SO many times i saw "$PM parser error " .what is meant by PM?

1 8616

CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

Wipro,

2 17073

Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com

2 4283

How can we use multiple data providers in a single report in business objects?

2 7932

Can more than 1 metric be applied on an analytic in business objects?

2172

What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

IBM,

2915

In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 11631

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2039

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

Magna Infotech,

4 10891

Un-Answered Questions { Data Warehouse }

Can informatica load heterogeneous targets from heterogeneous sources?

1188

Can we create universe with no cache??

2515

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

1556

Suppose we assign you a new project. What would be your initial point and the key steps that you follow?

1138

Why cognos decision stream is used?

1167

What is called materialized view?

1084

Why teradata is used?

1011

Explain by-group processing?

1005

How do you determine the number of sessions?

1065

What is deployment group?

1221

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9148

Slowly changing dimensions, types and where will you use them

1719

Difference between e-r modeling and dimentional modeling?

941

What is teradata and why it is used?

1103

Explain how merging helps to combine data sets.

1059

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