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

Name 4 output files that informatica server creates during session running?

1 13700

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 16144

What are limitations of joiner transformation?

Exilant, TCS,

2 21328

can we generate reports in informatica ? How?

3 22050

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 7458

How can we eliminate duplicate rows from flatfile,explain?

3 12015

After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?

2 7401

AT the max how many transformations and mapplets can we use in a mapping ?

Cap Gemini, Cognizant,

1 17391

What are slowly changing dimensions?

Informatica, Verinon Technology Solutions,

5 31075

What is the difference between OLTP and ODS?

4 28010

What is status code?

2 7255

What are the two modes of datamovement in informatica sever?

2 7098

What is confirmed dimension and fact?

7 19941

What are reusable transformations in how many ways we can create them?

2 9451

What is facttable granularity?

2 8386

Un-Answered Questions { Data Warehouse }

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2351

how to test reports in cognos?

1082

What is cfapplication tag?

1033

What are the different problems that ?Data mining? can solve?

2896

Explain multivalued dependency?

1048

Performance tuning( what you did in performance tuning)

2059

We know rollup component in abinitio is used to summarize a group of data record then why do we use aggregation?

1409

Can we take backup when the database is opened?

1101

Code the tables statement for a single-level (most common) frequency?

976

Write some methods to apply securities in framework manager model?

1171

What is abap? What are idocs?

1024

Explain what are the methodologies of data warehousing?

974

Which files are created during the session rums by informatics server?

1233

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 ?

2053

What is dimensional table?

1135

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