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

differnce between 8.2 and 9.1.3

1 4941

what the use of proc glm

Accenture, C Marc,

1 6989

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 10551

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 9293

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

Syntel,

2216

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

Syntel,

2 8133

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 14424

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 8152

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 7359

Can we create universe with no cache??

2575

Data WareHousing course in noida

1 3834

Best Data Ware housing training institute in delhi

3 6269

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 7421

Is there any target staging area in informatica not staging area

Syntel,

2634

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

IBM,

1 3695

Un-Answered Questions { Data Warehouse }

What are routines in datastage?

1386

What are the steps involved in designing a fact table?

937

What are the different types of data warehousing?

1013

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

1042

How many codd's rules are satisfied by teradata database?

1154

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

2245

what are the other factors of the database on which the loading performance depend?

1961

Explain the teradata primary index mechanics in detail with a diagram.

1045

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9310

Explain the difference between nodup and nodupkey options?

1091

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

2022

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

999

How can you import XML repositories exported from different tools like ODI

3604

What the difference is between a database, a data warehouse and a data mart?

1203

What are the new features of informatica 9.x at the developer level?

1110

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