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

You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..

3 6658

what is sql override?what is the use of it?

Sonata,

4 16264

can every transfomation reusable?how?

Wipro,

2 7841

how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)

Sonata,

2 6383

HOW TO HIDE Column in WEBI & DESKI?

6 18204

How to maintain Query subject’s relationships between Database layer and Model Layer? For eg - if 2 DB layer's query subjects are copied in Model Layer - Query subjects respectively, then Where should we define relationship of both Query subjects? Either in DB layer or Model layer?

1881

Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain

1974

How to Avoid the overlaping the blocks in WEBI.

3 14724

hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

1949

what is the main difference between sorragate key n primary key in one word

2 11544

I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record

Flextronics,

1942

What is the concept of using Dimension allocation "By Measure"? How Transformer use when computing the Base measue?

IBM,

2237

how can u avoid duplicate rows in flat file?

CTS, Wipro,

4 10766

How informatica recognizes mapping?

CTS,

2 7404

Is snow flake or star schema used? If star schema means why?

CTS, Sonata,

4 9493


Un-Answered Questions { Data Warehouse }

Where the cache files stored?

1018


What are the default statistics that proc means produce?

1050


How to create different types of templates?

990


Can we get 1st record through Informatica(without sequence number).

1483


What is derived metric?

995


my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4225


Explain sessions?

1073


What is a sparse index?

1092


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1986


Explain absolute filter?

988


Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1555


What do high confidence, low confidence and no confidence mean in explain plan?

1048


What is the reusable transformation?

1053


What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

1024


How to create Target definition for flat files?

1235