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

if we have a delimiters at unwanted places in a flat file how can we over come those.

2057

why should we go Teradata over Oracle,what is the main differences?

TCS,

4 12132

what is the hint? how to use it to reduce the query processing in program?

Cegedim,

3 7859

What are @FUNCTION?

4 7929

Why do we use QUIT commmand for proc datasets and proc sql ???

3 8982

1)Source file contains one record, I want 100 records in target file.

3 9337

Two source files contains same meta data third file contains different data types can I funnel that file.

2 8173

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 6121

I have 100 records how can I load at a time from the single time

1 5297

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 6748

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

iGate,

1 5279

hi,can you share with me about,what is prompt order,how it uses and how it creates

1 5649

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 8908

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4053

How to schedule the report twice in a day?

Cognizant,

2 10000

Un-Answered Questions { Data Warehouse }

What are the joins in teradata?

1028

What are the available primary index types in teradata.

1044

What is the difference between fastload and multiload?

1399

Give the benefits of data integration suite?

933

Can you explain new content durability?

1040

How we can covert server job to a parallel job?

1167

what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4539

What is difference between informatica power mart and power center?

1020

How to eliminate duplicate rows from flat file?

951

Describe the between keyword in teradata?

1048

Explain what is full load & incremental or refresh load?

997

What dedup-component and replicate component does?

1291

What is the function of aggregator transformation?

1097

What is the order of precedence of vldb properties?

1025

for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?

2141

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