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,

2279

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 3529

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

1 3872

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 6470

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

Keane India Ltd,

5 9178

What are the different caches used in informatica?

UST,

3 7257

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 6683

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

Wipro,

1 7248

what is factless fact table?

IBM,

3 8521

Issue with Update override at Target table in Informatica.

2 8721

Wht is difference between content store and content manager?

Satyam, Tech Mahindra,

2 20889

What are the different String functions used in Abinitio?

IBM,

3 59132

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

TCS,

1 41897

What are the prioritized Rules in as Transform function

1 8630

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 13074

Un-Answered Questions { Data Warehouse }

How we can covert server job to a parallel job?

1159

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1059

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1985

how you can enable bulk load mode in ti?

what are different storage options supported by oracle ?

2099

What is fact? What are the types of facts?

1122

What are the different ways to represent the loading of dimension tables?

939

What are some prerequisites for datastage?

1108

Your colleague installed microstrategy on solaris or unix without root access. Will he be able to start/ restart this server?

975

Explain in detail scd type 2 through mapping.

1050

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2179

What is abinitio?

1179

What is called a slice?

1036

can u give example for factless fact table

6665

How to join 3 database like flat file, oracle, db2 in informatrica?

1244

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