Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Data Warehouse Interview Questions
Questions Answers Views Company eMail

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

CTS,

2 9130

Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,

2042

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 22950

How can I disable the drill-down for the last level of my dimensional hierarchy ????

1 9621

In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;

1 4822

Can we create universe with no cache??

1 6020

how can we build one report from two data bases

IBM,

4 8813

data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat

2 5626

How many mapplets u have created? and what is the logic used

Mind Tree,

5 11931

why do we go for update strategy tr in SCD rather using the session properties?

IBM,

3 16986

The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports

1 3947

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 29120

Is it possible to design report layout in crystal reports without Database info?

2 8330

1) How can you use slowly changing dimension type 2 in Universe, Reporting and what would be the build process. 2) How can you identify the users in webintelligence not using the reports past few months. And delete them. 3) How can you move documents from one environment to other environment

Hexaware,

3 11149

What is the difference between In-Memory Sort and Inputs must be sorted?

3 24369


Un-Answered Questions { Data Warehouse }

What are the approaches used by optimizer during execution plan?

909


Explain rw document?

1099


how u will determine the performence tune will occur either in report or system

2137


How to extract sap data using informatica?

1042


How to test a cube?

2192


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2058


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3460


What is the difference between validated and compiled in the datastage?

1293


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

1020


What is is a data flow graph?

1123


What are the various methods of getting incremental records or delta records from the source systems?

931


Can you suggest us materials for sdtm mapping?

4448


What are the common features of Redshift?

5


What is Discrete and Continuous data in Data mining world?

2640


What are the types of facts in microstrategy?

1032