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

What is the sequence generator transformation in informatica?

1271

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1178

State the limitations where we cannot use joiner in the mapping pipeline?

1114

What if the source is a flat-file?

1178

What is the difference between source qualifier transformations source filter to filter transformation?

1100

Write the different tools in the workflow manager?

1122

What is an expression transformation in informatica?

1095

Explain the types of lookup transformation?

1116

How we can confirm all mappings in the repository simultaneously?

1 1534

Which is the t/r that builts only single cache memory?

1246

Why filter transformation is an active one?

1035

What are the components of the workflow manager?

1189

If informatica has its scheduler why using third party scheduler?

1314

How can you increase the performance in joiner transformation?

1250

What are the restrictions of union transformation?

1094

Un-Answered Questions { Data Warehouse }

How do you start developing a datastage project?

1166

How do you manage the Parameter files while migrating your data from one environment to another environment?

1073

When do we analyze the tables?

1027

What are system variables and sequencers in datastage

1194

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

1345

what are passthrough functions?

1013

What is an i-server? What are the different modes to run it?

1027

Explain why we use partitioning the session in informatica?

1174

How do you debug and test your SAS programs?

1615

Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

2159

What is the difference between s3 and redshift?

Is stop and abort are same in informatica?

1057

What are the limitations of amazon redshift?

Name the third party tools that can be used in datastage?

1149

Did you write stored procedures in teradata?

1197

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