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

why u go for dimensions ?

TCS,

3 9741

what are the difference between Informatica 7.1 and 8.1?

6 32165

Plz..let me know differences between Informatica 7.1 and 8.1?

3 11307

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 8563

How do we create row level security in cognos8?

3 10509

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

Tech Mahindra,

7 16640

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

TCS,

6 14862

What is an open session command in cognos connection?what is it meant for?

Infosys,

1 13887

Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)

Verinon Technology Solutions,

3 7627

What is meant by Tabular SQL in Cognos Report net

Infosys,

3 14937

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

Deloitte,

10 36756

what are the differences between powercenter 8.1 and powercenter 8.5?

2 9447

wht is full process of Information source to target just like stg to productuon and development

Informatica,

1 7090

what about data stage requirement

1 5281

what is power prompt in cognos ep7series?what is the use of this?

HCL,

3704

Un-Answered Questions { Data Warehouse }

What are the different servers in sas? : sas-grid-administration

1069

How to do performance tunning of reports?

2332

What do you mean by static and local variable?

978

Can you define a catalog and types of catalogs in cognos?

1072

Give some information on report bursting?

1009

What is a view as it relates to system modeling?

992

Which command is used to perform sorting in sas program?

1060

How rejected rows are managed in datastage?

1535

what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

1037

What is informatica? Why do we need it?

1123

What are the names of the layers in etl?

1014

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1011

Under which circumstances, informatica server creates reject files?

1111

Give some ways by which you can define the variables to produce the summary report (using proc report)?

1102

Explain pushdown optimization and types in informatica

1088

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