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

how to create a derived table in designer? i need steps regarding derived table

1 10647

how we can create optional or required parameters in SAS macro...

TCS,

5 23435

Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3622

How to calculate total memory used my a graph?

IBM,

1 14194

Is there any function in ab Initio which act like SCAN component

3 22166

If I delete 1 partition (in 8 partition multifile) and run the graph. Will the graph run successfully?, If not what error I'm going to get.

2 15683

Output for sort and dedupsort with NULL key?

6 29685

How many cubes create from a single model?

1 4644

1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.

2 5814

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 6127

1.What is the difference between _NULL_ , _ALL_, and _N_? 2.What are the uses of _NULL_ using in Data Steps? Can we _NULL_ in Proc Steps also? 3.How do call the macro variable in Data Steps? 4.How to construct Pivot tables in Excel Using SAS?

3 10326

Hello, I need help on passing parameter to Oracle Stored Procedure.I am a oracle DBA,need to use some graphs. I need help to pass date parameter with format YYYYMMDD from Ab Initio to Oracle STored Procedure.How to do that please explain me...

1 10618

How to Create users in cognos Access Manager from 1) front end 2) back end

TCS,

1 9041

1)How can we do the Union in Report Studio? 2)What is the meaning of Aggregation and Rollup Aggregation? 3)How can we hide the columns in Report Studio and How can we view the hiding Objects? 4)Can we provide joins in Report Studio and in which situation we can go for outer join? 5)If we take a Date Prompt and run it once it will show default data,how can we change it exact 1 month back data?

1 12457

is there any difference between proc summary and proc means?

3 9192

Un-Answered Questions { Data Warehouse }

What is the purpose of interprocessor stage in server jobs?

2244

How substr function works in sas?

1232

how do u implement configuration management in Informatica?

4802

What are pre and post-session shell commands?

1327

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

2224

How do you use reject loader.

2618

Did u used latest transformations of 8.6.0? for what?

1899

how we can load rejected record's at run time?(not through bad files)

2390

What is by-group processing?

1010

What are the enhancements made in datastage 7.5 compare with 7.0?

1158

What are the key configuration files in obiee?

972

How is the number of passes in a sql query significant in performance evaluation?

978

What is the order of precedence of vldb properties?

1026

Explain the tuning lookup transformation - informatica

1005

Slowly changing dimensions, types and where will you use them

1728

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