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

differnce between 8.2 and 9.1.3

1 4851

what the use of proc glm

Accenture, C Marc,

1 6904

Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?

Mphasis,

2 10425

Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?

Mphasis,

5 9104

Can anyone tell me the new features in Informatica 9 Version?

Syntel,

2130

Can anyone tell me the new features in Informatica 9 Version?

Syntel,

2 8016

Can anyone please help me out,In which transformations records will be rejected and how capture those records?and How to reload the rejected records?

Syntel,

3 14278

here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.

Cap Gemini, L&T,

2 8022

I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?

IBM,

3 7224

Can we create universe with no cache??

2509

Data WareHousing course in noida

1 3726

Best Data Ware housing training institute in delhi

3 6147

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

Accenture,

2 7291

Is there any target staging area in informatica not staging area

Syntel,

2580

How to fix the etl bugs..Tell me the process?

IBM,

1 3615


Un-Answered Questions { Data Warehouse }

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

1024


What does sleep function does in fast load?

1142


What is grain of fact?

982


What are target types on the server?

995


Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

1199


what are passthrough functions?

958


How can we run the graph?

1069


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

1165


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2274


What is called Cognos powerplay?

1083


Why is sorter an active transformation?

1129


What is the command used to run a batch?

1065


What are the different operating system platforms in which we can use sas? : sas-grid-administration

1073


Explain what task is 98% of the required work of a business analyst?

1104


Name the different types of Lookups in Datastage?

1263