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 EME?What is GDE?What is Co-operating system?What is the link between all these?Please explain elaborately.

1 13215

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

Polaris,

2796

what is procedure to use mapping variable in source qualifier transformation? with example

IBM,

1 7418

how to create a sample mapping for dynamic lookup transformation

2 5336

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 3407

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

1 2139

What is conditional DML and Structured DML?

Accenture,

2 28295

Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........

TCS,

1 3941

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

TCS,

2 4430

explain different levels in pushdown optimization with example?

TCS,

2 7424

waht type of interface is used for testing the data in informatica

CTS, TCS,

1 2320

wat are deployement groups in informatica, how it will be used for developers

1 1799

what is the difference between informatica6.1 and infomatica7.1

TCS,

1 2412

can we use union transformation in joiner transformation?how?

Dabur, Tech Mahindra,

1 9187

Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3

CTS,

3 9121

Un-Answered Questions { Data Warehouse }

Write the unconnected lookup syntax and how to return more than one column.

1176

How do you remove duplicate records in informatica? And how many ways are there to do it?

1237

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1202

What is the purpose of Dataware Control?

1121

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2828

Hi, If anyone has base SAS certification dumps, please share.

1943

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2495

How to add default rules in transformer?

1288

draw informatica architecture 8.6 ?

3951

How to create the source and target database connections in server manager?

1144

explain in detail about type 3?

1093

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1200

What is dimensional table? Explain the different dimensions.

1273

Explain scd type 3 through mapping.

1078

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2438

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