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 12823

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

2 5021

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

4 26348

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 3711

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 6018

How to do performance tunning of reports?

1921

Where do we use ACvisitor class?

2106

What property you use to Hide a control at runtime?

2 4891

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

2126

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

1 5268

How can you change the group key dynamically?

L&T,

1 3677

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

Mphasis,

2 5510

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

Mind Tree,

2 6722

What is the difference Between Mapping parameter and variable

Accenture,

3 9007

What is update override?

Accenture,

1 5888


Un-Answered Questions { Data Warehouse }

What is meant by a dispatcher?

553


How can one identify whether mapping is correct or not without connecting session?

865


Compare and contrast aggregates & indexes

3335


what are the deliverables?in your project?

1642


I need a good brd and uc template?

577






What are shortcuts? Where it can be used? What are the advantages?

539


What is node? How many nodes and amps used in your previous project?

661


what does the run statement do? : Sas programming

544


How to do the error handling of if ur source is flatfiles?

1495


Explain fact table?

635


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1038


How to get sql from obiee for reports?

525


Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1550


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1909


I need level 2 to 5 sas using companies in india

1917