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

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

IBM,

1 2350

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

IBM,

1 3634

HI, can anybody tell me aggrigate awareness is only for aggrigate tables or if any?

1 3968

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

TCS,

3 6642

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

Keane India Ltd,

5 9426

What are the different caches used in informatica?

UST,

3 7419

If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?

Hexaware,

1 6838

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

Wipro,

1 7331

what is factless fact table?

IBM,

3 8735

Issue with Update override at Target table in Informatica.

2 8858

Wht is difference between content store and content manager?

Satyam, Tech Mahindra,

2 21079

What are the different String functions used in Abinitio?

IBM,

3 59477

What is Is_defined(), Is_null(), Is_Blank()?

TCS,

1 42106

What are the prioritized Rules in as Transform function

1 8752

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

DELL, TCS,

5 13288

Un-Answered Questions { Data Warehouse }

EXL informatica Questions

1463

what are the data modeling tools you have used?(polaris)

2060

Hi friends, what are the new features in abinito3.0?

2860

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2068

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1245

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8288

Have you have ever worked in unix environment and why it is useful in datastage?

1217

How would you format some text using css to be verdana and bold?

1150

What r the names of the reports that you prepared?

1032

What is the purpose of Dataware Control?

1121

draw informatica architecture 8.6 ?

3949

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1178

What is a rollup component? Explain about it.

1246

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2345

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2214

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