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 13208

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 7413

how to create a sample mapping for dynamic lookup transformation

2 5332

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

1 3403

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 28290

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 3938

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

TCS,

2 4427

explain different levels in pushdown optimization with example?

TCS,

2 7422

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

CTS, TCS,

1 2316

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 2406

can we use union transformation in joiner transformation?how?

Dabur, Tech Mahindra,

1 9183

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

CTS,

3 9116

Un-Answered Questions { Data Warehouse }

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2772

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

1202

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

1200

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

2495

how to generate the test data in sas without input data? : Sas-administrator

1207

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2176

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1178

Write the unconnected lookup syntax?

1153

What is aggregate table and aggregate fact table ... Any examples of both?

1121

2796

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2266

What is the purpose of Dataware Control?

1121

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1853

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1998

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