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,

7195

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

Accenture, Gcs, TCS,

119 117906

how to join two flat files in informatica?

Wipro,

3 19157

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

Wipro,

4 9517

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 9722

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

Cognizant, Wipro,

2 6768

how can we run workflow with pmcmd?

Wipro,

3 8848

what is bridge tables in informatica

CTS,

1 10015

what is the -ve test case in your project.

CTS, TCS,

2419

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

Polaris,

13 24522

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 17207

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

1 5379

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 9965

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 23757

why union transformation is active transformation?

IndiGo, TCS,

6 24270

Un-Answered Questions { Data Warehouse }

Explain static reports?

1011

Explain the difference between keylokup and joiner?

897

What is the ab initio business rules environment (bre)?

1180

what is granularity in Data ware House?

1735

how to write server Routine coding?

2133

What are the benefits of datastage?

1239

Explain me ETL project architecture in Detail?

2380

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1983

What is level prompt?

966

what the mean of version error in crystal?

2401

what is the difference between floor and ceil functions in sas? : Sas-administrator

1266

What are the advantages of shortcuts?

968

Explain how many universes can be created in a project?

1071

Name validation tools used in SAS

1188

What is the difference between INPUT and INFILE ?

1331

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