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 5055

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 8654

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 7507

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 8177

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

TCS,

1 6346

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 7109

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

TCS,

1 4970

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

TCS,

3 14207

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 8993

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

TCS,

6 12317

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 13723

What is a post baseline?

1 3226

Can you suggest us materials for sdtm mapping?

TCS,

4448

what is a post baseline?

Accenture,

2 9389

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

Cap Gemini,

3 8590

Un-Answered Questions { Data Warehouse }

hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit

2050

What is the function of output statement in a SAS Program?

1074

What is thumbnail?

975

What does the RUN statement do?

1308

Write a program to show the parser component used in teradata?

982

What are the types of catalogs in cognos?

1144

Informatica settings are available in which file?

992

------------ Diff b/w MemberCaption and MemberDescription?

2318

What could be the possible resons of locks by user?

1094

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2306

Why do we use exception activity in Datastage?

1317

What are the key features of chameleon that separates it from other algorithms?

1121

Describe an informatica powercenter?

1127

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

2079

AE datasets names? how many types?

2506

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