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

4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 please send me answer this question my mail

1 5072

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

TCS,

3 8679

IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me

Accenture,

2 7531

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

TCS,

2 8198

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

TCS,

1 6365

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

TCS,

2 7128

Display all files which have size more 3KB in given directory/folder.

TCS,

1 4988

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

TCS,

3 14233

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

TCS,

2 9005

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

TCS,

6 12356

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

TCS,

2 13738

What is a post baseline?

1 3242

Can you suggest us materials for sdtm mapping?

TCS,

4459

what is a post baseline?

Accenture,

2 9417

How to answer the question how many fakt table in your datawarehouse and what size it have?

Cap Gemini,

3 8610

Un-Answered Questions { Data Warehouse }

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1104

What are the different types of metrics available in microstrategy?

989

what are the devoleper roles in real time? plz tell i am new to datastage....

2173

can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2269

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

2567

In a star schema, are foreign key constraints between facts and dimensions neccessary?

990

What is dtm?

1177

How is security handled?

1011

Describe implicit attribute?

1026

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2122

Compare ETL & Manual development?

967

how can we analyze the locks ?

2146

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1122

How can you set the session management?

1135

Do you find any difficulty while working with flat files as source and target?

1113

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