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.

2103

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

TCS,

4 12291

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

Cegedim,

3 8007

What are @FUNCTION?

4 8116

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

3 9153

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

3 9489

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

2 8273

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

2 6246

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

1 5368

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 6867

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

iGate,

1 5337

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

1 5725

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 9074

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.

4104

How to schedule the report twice in a day?

Cognizant,

2 10127

Un-Answered Questions { Data Warehouse }

How scientific data processing is different from commercial data processing?

1146

What is a sequence generator transformation?

1081

Difference between cold fusion 5 and cold fusion mx 6?

1060

How do we execute sql file on redshift?

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2612

Is union transormation is active transformation?

1034

What is MPP. Is Redshift support MPP?

How the users created differs from rpd/answers/dashboards level?

864

Differentiate database data and data warehouse data?

1172

How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

2134

Explain attribute?

1044

Fact table is in normalized or de-normalized form?

1042

in sap bi we have wad, then why we go for sap bo

3439

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1582

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1869

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