Data Warehouse Interview Questions
Questions Answers Views Company eMail

Where do i get Free COGNOS 8 Certification Dumps Downloaded for these codes COG-105, COG-112, COG-122, COG-125, COG-132, COG-135, COG- 142, COG-145, COG-180, COG-200, COG-205, COG-300, COG-310, COG-400, COG-480

7 12890

how to identify new and old values in source qualifier or any other transformations using informatica

2 5046

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 26394

It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....

2 3738

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

Wipro,

3 6051

How to do performance tunning of reports?

1936

Where do we use ACvisitor class?

2119

What property you use to Hide a control at runtime?

2 4924

How do you design a report which has multiple child datastream (horizontal seq)

2144

How do we have left -right flow , normally its top-down flow

1 5287

How can you change the group key dynamically?

L&T,

1 3709

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

Mphasis,

2 5550

How to fix the order of Prompts? How to assign the default value in prompt?

Mind Tree,

2 6756

What is the difference Between Mapping parameter and variable

Accenture,

3 9051

What is update override?

Accenture,

1 5918


Un-Answered Questions { Data Warehouse }

Difference between informatica vs ab initio?

715


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

1910


Did you face any problems while creating reports? Name? Solutions?

3262


Explain the definition of normalized and denormalized view and what are the differences between them?

522


What is cubes?

623






what are the basic features of cognos tm1?

5


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.

1856


Difference between multiload and tpump?

623


What are teradata utilities?

590


What Is The Difference Between Oltp And Olap?

682


explain the proc in sas? : Sas-administrator

626


what is song in infrmatica...?

1681


How can you limit the variables written to output dataset in data step?

757


How to differentiate between the active and passive transformations?

631


What is the sql query overwrite in source qualifier in informatica

619