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 environment variables and parameters?

1 8270

how many types of project we can create in Abinitio? I mean public,private.......etc?

1 8392

To which project that prefix will set is to private project or public project or both?how and where to set?

1851

what is the project environment(for each project the environment is same or different to different project)?

2223

I have a DML in my local system the location is E:/u/home/khaleel/dml how to convert this path to $DML?

1 4241

What is the difference between formal and export parameter? Export at what secenario we are going to use?

2639

I have $AI-SERIAL/DML------> (SERIAL FILE LOCATION) AND $BDS-SERIAL/DML---------->(what is the location what is mean)?

1 4638

How to create project (public,private,common,client) what are the differences between them?

TCS,

1 8588

)what is wrapper script?where it is going to execute and why we go for wrapper?

Satyam,

1 16176

How to move or copy the project parameter or project object to my sandbox?

2308

what is the difference between usersandbox,privatesandbox,publicsandbox,commonproject sandbox?

4001

what is the use of catlog or catlogfile?

2381

what is SSH?What is the differences between the SSH,SSH1,SSH2?

2 10332

what is the use of stdenv in abinitio and what the main concept belongs to is?what is env?

1 12482

How to move data from developement to testing and testing to production?

BitWise, CTS, Satyam, Wipro,

1 14927

Un-Answered Questions { Data Warehouse }

explain about citrix scheduling tool in datastage

2457

What is the difference between Standard and Metrics folder?

1082

Write the unconnected lookup syntax and how to return more than one column.

1111

How does a sorter cache works?

1072

How to partition the Session?

1113

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9827

Explain what are data marts?

1122

Can you explain the advantage of using shortcuts?

1029

What is meant by drill down?

977

What is surrogate key? Explain with examples.

1158

What are the methods by which it non-durable model could be changed into the durable model?

959

Define Job control?

1149

What is a connected transformation?

1120

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1677

How to improve the performance of a session using sorter transformation?

1147

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