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 8986

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,

1995

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 22695

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

1 9529

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 4730

Can we create universe with no cache??

1 5908

how can we build one report from two data bases

IBM,

4 8624

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 5511

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

Mind Tree,

5 11728

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

IBM,

3 16845

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

1 3846

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

3 28918

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

2 8196

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 11011

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

3 24157


Un-Answered Questions { Data Warehouse }

Explain what is metadata reporter?

911


what is the use of materialized view?

1489


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2511


What can you learn from the SAS log when debugging?

1317


How substr function works in sas?

1159


What are the types of caches in lookup? Explain them.

925


List out some of the primary characteristics of teradata.

929


Have you ever encountered an error called “depth not equal”?

1113


differentiate between power play transformer and power play reports?

5


Explain load alternative records / rows into multiple targets - informatica

1104


What is the report studio?

981


Mention what information does a .dbc file extension provides to connect to the database?

1250


what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

970


what is the meant by Normalization and de-normalization?

2651


How will you execute direct sql in obiee?

864