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 hints in cognos and where we use it.

2536

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2799

source contains 2 columns comes to target 4 columns how

IBM,

1 5247

how to validate the jobs

IBM,

2 7713

Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates Like jan-SEP How can We Achieve This one?PLS Expain Me With Ex:

3 8026

Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastname?how I'll Get This One?Pls Ans Me

2 5507

Hi, I Want To Display The Report. From MOnday To Friday By Using Date Prompt.PLs Expain To Me...

1 4886

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 8262

what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

HCL, IBM,

2 11026

SAS using companies in chennai

1 5312

Main Function of the Staging area in DWH ?

2 6577

In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

TCS,

1 6514

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

TCS,

1 4329

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

Cap Gemini, TCS,

3296

what is the exact difference between dataset and fileset in datastage?

TCS,

5 46120

Un-Answered Questions { Data Warehouse }

Can we start and stop single session in concurent bstch?

987

Can there be sub steps of etl steps?

1109

what are the reports developed in sap bw project and what is the requirement for developing it?

2229

Hi, If anyone has base SAS certification dumps, please share.

1930

Tell e how how dealt with..

2315

How can we increase the loading performance of oracle table in AbInitio?

1217

How to compare two dmls in abinitio

1884

What are aggregate transformation?

1094

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2061

How to implement security measures using repository manager?

1246

What are the components of the report studio?

1254

Explain what is the difference between native sql and cognos sql?

1053

what is the main advantage of impromptu over cognos reportnet?

1094

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1016

Did you write stored procedures in teradata?

1193

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