Data Warehouse Interview Questions
Questions Answers Views Company eMail

what i the difference between the flows of 3 paralellisms

1 5552

What is slicer & dicer ? what is sub session parameter ?

Cap Gemini,

2 12739

Approximately what date is represented by SAS date value of 730

9 18733

How to create an popup in the WEBI report if the report is showing partial result?

Banking, IBM,

2 8578

how to move the mappings from your local machine to claint place?

2 5841

What is a data modeling?

2 5702

What is A complex mapping?

TCS,

3 11788

What is A cache?

2 6014

How to load relational source into file target?

IBM,

3 7236

How the Informatica Server reads perameter file?

1 5289

What are the phases in SDLC?

3 8331

How to load a relational source into file taget?

2 6091

What is a unit Testing?

1 4800

What is a poling?

2 6226

What is a design?

1 3126


Un-Answered Questions { Data Warehouse }

What are symget and symput? : sas-macro

717


Highlight the main features of datastage?

610


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1541


What happens in a conflict? How do you handle that?

612


Why is data processing considered beneficial?

607






Explain the difference between holap and rolap?

562


can we override a native sql query within informatica? Where do we do it?

617


Explain how to generate iqd file from framework manager?

499


Can you define cube?

571


Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

905


How to pivot data using informatica when you have variable amount of pivot rows?

509


What is the definition of cube in datawarehousing?

549


Explain do we need an etl tool? When do we go for the tools in the market?

607


Sequence generator, when you move from develoment to production how will you reset

1394


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3838