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

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

HCL,

7199

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

Accenture, Gcs, TCS,

119 118100

how to join two flat files in informatica?

Wipro,

3 19166

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

Wipro,

4 9524

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

Wipro,

5 9732

in what type of scenario bulk loading and normal loading we use?

Cognizant, Wipro,

2 6774

how can we run workflow with pmcmd?

Wipro,

3 8854

what is bridge tables in informatica

CTS,

1 10019

what is the -ve test case in your project.

CTS, TCS,

2428

how to retrive the max(sal),deptno,empno in datastage?

Polaris,

13 24565

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

Polaris,

10 17222

Can any body suggest me that Drill through of packages is possible? If yes, how it can be done?

1 5387

im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?

IBM,

6 9979

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

Accenture,

3 23771

why union transformation is active transformation?

IndiGo, TCS,

6 24285

Un-Answered Questions { Data Warehouse }

What is an i-server?

1076

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5136

Which studio is used to create reports?

1126

what is sas application server? : Sas-di

1094

What is proc sort?

1237

How can one identify whether mapping is correct or not without connecting session?

1462

What are the roles defined by cognos platform?

1163

How you prepared reports for OLAP?

1614

Define olap designer?

1141

How to manage date conversion in Datastage?

1149

Differentiate primary key and partition key?

997

Compare microstrategy and tableau.

993

what is the main role of FI on business

2120

Can you explain the advantage of using shortcuts?

1043

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2532

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