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 15109

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 9520

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

IBM,

3 14402

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

2 7464

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 12335

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

CGI,

1 11298

what is surrogate id ?

IBM,

3 8438

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

3 9457

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

2111

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

IBM,

2 9776

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,

2373

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

IBM, TCS,

2 10985

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 10050

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 8906

What are the Aggregate functions in SQL ?

AON,

2 8129

Un-Answered Questions { Data Warehouse }

Explain which are the olap tools available that are supported by oracle?

1013

What are the issues you have faced in your project? How did you overcome those issues?

2372

How to implement complex jobs in data stage?

1118

how to connect to a flatfile through ftp in informatica

14311

Explain the data types present in bo and what happens if we implement view in the designer and report?

1037

What is the advantage of informatica?

1071

what is null hypothesis? why do you consider that?

2912

name the components of report net?

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1842

CHANGE CAPTURE

1311

What are the new features of informatica 9.x at the developer level?

1049

What is called partitioned primary index (ppi)?

1018

How abinitio eme is segregated?

1289

What is the difference between datastage and informatica?

1123

What are the steps of implementing data warehousing?

1050

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