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

Can we create Hierarchies in generic datasources?

CTS,

2431

How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?

2 5837

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 7657

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 6626

What is user docs and how to use this option in bo?

Bank of Baroda,

1 3652

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

Ness Technologies,

2 7545

How can we get two output ports in un-connect transformation?

Ness Technologies,

2 7580

what is the complex transformation you used in informatica

TCS,

2627

permutations of mapplet

TCS,

2551

what is the flat file partition and where have to specify it

TCS,

1 7751

Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

1 5200

Can we call a stored procedure from a unix script which is run using command task

TCS,

1 7195

Can anyone briefly describe abt audit table loading?

TCS,

2 7054

can anyone explain me about retail domain project in informatica?

Zensar,

8006

waht is dataware house

2 4902

Un-Answered Questions { Data Warehouse }

What is the commit type if you have a transaction control transformation in the mapping?

1100

How to Create a folder using pmrep command?

1226

Explain the difference between the truncate and delete commands?

1216

What is maximum number of rows and cols can be handled in SAS?

1678

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1216

Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2134

Can you explain players in datastage?

1255

What you can store, manage and reuse centrally in ab initio enterprise meta>environment (eme)?

1301

In the Primary Index, what is the score of AMPs that are actively involved?

1138

Have you worked with/created Parameter file

1716

Is there any difference in testing database and data ware housing?

2811

What do you mean by the term data warehousing? Is it different from data mining?

1284

What is a Framework manager?

1082

how to write server Routine coding?

2185

How do you import and export the datastage jobs?

1215

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