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 8362

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

1 8476

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

1916

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

2284

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

1 4312

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

2681

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

1 4729

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

TCS,

1 8718

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

Satyam,

1 16244

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

2370

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

4045

what is the use of catlog or catlogfile?

2430

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

2 10458

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

1 12565

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

BitWise, CTS, Satyam, Wipro,

1 15045

Un-Answered Questions { Data Warehouse }

How do you schedule or monitoring the job?

1273

what is degenerated dimension?

4102

hi,can you please share with me about,what is reportlimit,report order and how can create and use

5331

What is stored procedure in teradata?

1093

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2414

What is the difference between where and if statement?

1153

i have a scenario where i need to change the value of a sort order in my sort component whether ascending or descending depend on some input value... e.g if input_val = A then sort order should be ascending else descending I have to use PDL in this... Can you please tell me where do i have to make this change and how ?

2116

What are the guidelines to be followed while using union transformation?

1211

how would u estimate the size of Aggregator transform data and index cache?

2010

Explain what is partitioning? What are the types of partitioning?

1015

how many modules are there in telecome domain?how to explain the architecture?

2068

How to get sql from obiee for reports?

933

What is PDV?

1209

What are the steps involved in etl process?

1105

What do you understand by local lookup?

1217

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