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

What are the major problems will occur while migrating to the one version to another version?

CTS,

2 7230

What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way?

CTS,

2 16723

what is the diff b/w switch and filter stage in datastage

Cap Gemini,

2 16662

How we can get unique records into one target table and duplicate records into another target table??

Deloitte, IBM, iGate,

11 41299

HI ALL, CAN ANY PLEASE TELL ME HOW TO CREATE HYPERLINKS IN WEBI.THANKS IN ADVANCE

2 6310

how to cleansing data

Cap Gemini,

6 17315

how to prepare scd2 in abinitio

CTS,

1 21570

How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,

1 22094

when will we go for unconnected lookup transformation in Informatica?

CTS, IBM,

6 24586

How u provide security to reports in report studio or in cognos connection?

Cap Gemini,

1 10253

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

UHG,

4190

What is a range lookup?

IBM,

2 7783

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 9357

hi all, Can anyone please tell me the relationship between informatica and business objects

1 4581

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2175

Un-Answered Questions { Data Warehouse }

How do you setup Lo-cockpit?

3172

Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.

2219

Can Bo generates the Report from the cubical data Explain?

2039

What is the good sas programming practices for processing large data sets?

1127

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1115

What is the difference between orabulk and bcp stages?

1028

What is brodcasting and replicate?

1215

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2295

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

2204

Informatica settings are available in which file?

995

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1156

Define ds designer?

1285

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1555

What is the purpose of upsert command?

1181

Difference between e-r modeling and dimentional modeling?

941

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