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

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 7996

In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?

IBM,

2 4993

What is RCP

CGI, CTS,

5 22058

How can we achive parallelism

CTS,

1 7971

How to hide value prompt box and list when run report?

IBM,

4 8721

How to select all in value prompt instead of cascade prompt?

IBM,

3 8818

I have to apply drill through 1,2,7 out of 10 in order method, how can i do?

Satyam, TCS,

1 5058

im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?

IBM,

1 5154

1)how to generate sequnce numbers in informatica without using sequnce genarator transformation. 2)i have number of records in my sourse, but iwant to display first and last record only. how it is possible in informatica. 3)i want to update the records without using updatestrategy transformation. 4)what is diffrance between ab-intio and datastage than compared to informatica. 5)what is the latest version of informatica in our field.

CTS,

5 36474

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

CTS,

1 7306

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 9375

example for generated prompt

1 4694

What is Data Vault???

1 2797

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

TCS,

2 7599

what is dynamic sort?

Infosys,

1 6287

Un-Answered Questions { Data Warehouse }

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2540

Write the unconnected lookup syntax?

1139

What is the purpose of Dataware Control?

1110

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2161

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2168

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2099

Are you involved in writing the inferential analysis plan? Tables specifications?

4011

Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1093

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8274

What is dimensional table?

1144

How would you format some text using css to be verdana and bold?

1133

What is node? How many nodes and amps used in your previous project?

1167

Demonstrate experience in maintaining quality process standards?

2658

Explain how to generate iqd file from framework manager?

1010

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2122

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