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

Is it possible to create a parameter in the component?

1 9348

what is macro?At what situation we have to face?

1 6153

How to implement the funtionality in the custom component to use in the graph?

1 4412

What is publickey and private key?what is the use of this two keys?

2911

After completion of graph what is the next process to perform? who will perform the later process?

1 8586

Report have 10000 records,how to restrict the end user to 1000 Records?

6 9621

IS THERE ANY OTHER TOOL AVAILABLE TO DESIGN/CREAT UNIVERSE? EXCEPT UNIVERSE DESIGNER

IBM, TCS,

3 9066

I have scheduled a weekly report to client. If the data is Over which client wanna receive what will happen?

Rolta,

2 3901

I HAVE USED A PROMPT TO SELECT A COUNTRY IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN DEFAULT AND HAVE TO GIVE THE RESULT? HOW TO ACHIEVE THIS?

BirlaSoft,

3 8982

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

iNautix,

1 6717

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

iNautix,

5 9420

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

iNautix,

7 21794

hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........

1 6642

what type of problem you faced insales project or insurance project

Sony,

1 5205

What are links & Segments in Cognos Framework Manager?

Systime,

1 11324

Un-Answered Questions { Data Warehouse }

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1698

Explain what are the tasks that loadmanger process will do?

935

What is the difference between absolute filtering and standard filtering?

1059

Your application mode has crashed. How would you run your i-server?

993

What are the different etl testing categories as per their function?

1090

How do you see a ddl for an existing table?

1026

I am unable to connect sever database(oracle) from gde(db config file) local system.i set all these?

1167

What does role playing dimension mean?

1053

Is Redshift similar to RDS ?

Define the various join types of joiner transformation?

995

What are data validation strategies for data mart validation after loading process?

1023

What are the features of base sas system?

1079

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2902

Explain the term 'primary key' related to relational database management system?

1049

Differentiate between router and filter transformation?

1020

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