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 the end to end process meaning in my project(my project is development)and functionality plz tell me

2001

with out using update strategy transnsformation how to update the data in mapping level

1 4831

how to get the only updated records in the target

2 6267

how to get flatfile containg 10 records half records one target another half another target

2 5533

i'm searching on cognos..i want to know real time project explanation..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details for project and interview preparation..pls help me out..my mail-id is al.ramu@yahoo.com hope u will respond as soon as possible..thanks..

1 3169

what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance

IBM,

2 7683

what is the difference between MOLAP and ROLAP?

3 8815

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 22136

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

Accenture,

6 12164

How to improve the session performance in informatica?

Accenture,

3 21524

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979

how to import XTP files into SAS datasets?

Barclays, Institute For Plasma Research,

1 8588

how to import HTML files into SAS datasets?

HP,

3 16018

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

JPMorgan Chase,

3346

how can or from where we can get reference data in scd type2 implementation?

JPMorgan Chase,

2 7399

Un-Answered Questions { Data Warehouse }

Highlight the differences between Primary Key and Primary Index.

1091

What are the main components of teradata system?

1135

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2271

what are passthrough functions?

957

What is the difference between SAS functions and procedures?

1152

What are the types of schemas we have in data warehouse and what are the difference between them?

941

What is mean by aggregate aware?

1085

What makes sas stand out to be the best over other data analytics tools?

1070

Explain the new features of teradata?

1045

What is a mapplet/worklet in informatica?

1188

Enlist the advantages of informatica.

1068

What are the advantages of shortcuts?

968

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

2413

What are shortcuts? Where it can be used? What are the advantages?

1073

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8119

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