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

Which is better performance wise database or file?How?

2 6633

I am having 10 records in i/p file,and i want to load only one record at a time to the output file.Then how can i do it?

IBM,

2 8710

Can any body give me the clear explanation about how to separate header,trailer and body records in Ab Initio?

TCS, Wipro,

2 18712

from a graph how to select only second record always in scan?

IBM,

3 13964

Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 4106

How u use pdf file in informatica source?

Ericsson, HP, IBM,

2 7219

What is joiner cache?

TCS,

2 6622

What is use of batch file in informatica? How many types of batch file in informatica?

EXL,

2 19843

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 6197

Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x

7 11287

I want to run one page with filter and another page without filter, what is process?

1 5070

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 4034

Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

2202

How can i send first half of the records to one target and Remaining to other target?

TCS,

10 29732

If the records doesnt satisfy the filter condition where will it go?

IBM,

10 16356

Un-Answered Questions { Data Warehouse }

What are the data types present in bo? What happens if we implement view in the designer n report?

945

What are all the types of hierarchies?

1141

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1843

What is a put statement?

1211

What is the difference between server job and parallel jobs?

1165

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4170

What are the Graph parameter?

1169

Which algorithm you used for your hashfile?

1190

Where is teradata rdbms used?

1108

how can you get the errors in job? when loops are araised we get error?

2132

Can you execute a macro within a macro? Describe. : sas-macro

1116

What is an olap designer?

976

what is the basic structure sas administrator? : Sas-administrator

1010

Why did ibm cognos tm1 web change the technology from .net to java?

What are session parameters ? How do you set them?

1860

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