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,

2284

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 3538

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

1 3883

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 6478

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

Keane India Ltd,

5 9184

What are the different caches used in informatica?

UST,

3 7263

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 6692

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

Wipro,

1 7253

what is factless fact table?

IBM,

3 8541

Issue with Update override at Target table in Informatica.

2 8728

Wht is difference between content store and content manager?

Satyam, Tech Mahindra,

2 20899

What are the different String functions used in Abinitio?

IBM,

3 59143

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

TCS,

1 41907

What are the prioritized Rules in as Transform function

1 8637

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 13094

Un-Answered Questions { Data Warehouse }

Can you explain cognos tm1?

Explain what is the difference between microstrategy and cognos reporting tool?

1091

What is sorter transformation?

1064

-----------------What is Direct and Conventional loading?

2184

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2202

What are the features of SAS?

1050

How to go to the older version for a mapping?

1117

Explain what is de-partition in abinitio?

1360

what is data modeling?

2328

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

2013

What is the importance of having monitor service in cognos?

1046

What are pdv and it functions?

1168

What is the use of having index on table?

1019

How abinitio eme is segregated?

1297

What is the function that transfers a string into a decimal?

1175

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