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

How we khow a database is connected in Abinitio?

2 15221

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

TCS,

3 9674

pls ans what are the filters we have in framework manager? filters in report studio?

IBM,

3 14541

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 7564

souce file having the columns like name company krish IBM pooja TCS nandini WIPRO krish IBM pooja TCS if first row will be repeat i want the result like this name company count krish IBM 1 pooja TCS 1 nandini WIPRO 1 krish IBM 2 pooja TCS 2

9 12586

Performance wise which is better joiner or look up ? Give me with example?

CGI,

1 11386

what is surrogate id ?

IBM,

3 8598

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 9578

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2153

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

IBM,

2 9906

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

IBM,

2414

What is best approach to load 100 different source files (Different structure) to differet target tables ?

IBM, TCS,

2 11100

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

IBM,

2 10140

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

IBM, WalMart,

2 9008

What are the Aggregate functions in SQL ?

AON,

2 8256

Un-Answered Questions { Data Warehouse }

Give some information on report bursting?

1046

design of staging area?

2080

what is broad cast agent? : Sas-bi

1124

How can you export a component’s internal parameters ?

2460

How analytics process your request when you create your requests?

1000

What is the difference between match merge and one to one merge?

1328

-----------------What is Determination Model?

2176

What you mean by drill across and what is the difference between drill through, drill across?

1088

What is usage analysis in datastage?

1365

How do I create and delete a cluster in aws redshift?

What is full load & incremental or refresh load?

1250

What is a general purpose scheduling tool?

1182

When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort

1026

3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.

2685

Can we test the report other than manual testing?

2227

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