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

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 6843

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

Sonata,

4 16523

can every transfomation reusable?how?

Wipro,

2 7992

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

Sonata,

2 6559

HOW TO HIDE Column in WEBI & DESKI?

6 18459

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?

1956

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

2039

How to Avoid the overlaping the blocks in WEBI.

3 14920

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

2021

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

2 11685

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,

2004

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

IBM,

2338

how can u avoid duplicate rows in flat file?

CTS, Wipro,

4 10943

How informatica recognizes mapping?

CTS,

2 7533

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

CTS, Sonata,

4 9698

Un-Answered Questions { Data Warehouse }

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2546

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1849

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2169

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1196

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2060

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1200

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1100

How to create the source and target database connections in server manager?

1144

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

846

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4796

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2104

what are the names of the reports that you prepared?

1193

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1042

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