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

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 2860

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

HCL,

1 1568

Can anyone tell me what are the roles and responsibilities of informatica support ( L1, L2, & L3 ) Team?

IBM, Saama Tech, Wipro,

1 2000

How to increase performance without changing anything in mapping.( In prod)

IBM, Saama Tech, Wipro,

1 1326

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

IBM, Saama Tech, Wipro,

1 1265

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

1 1405

What are the different ways to deploy the code in informatica?

IBM, Saama Tech, Wipro,

1 2538

I have two tables in two different database, so to join these tables which transformation will be better joiner transformation or lookup transformation?

Accenture, Saama Tech, TCS,

2 3913

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

Cap Gemini,

1 3005

Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

CTS,

1 1443

On which transformations you created partitions in your project?

Cap Gemini,

1 1469

Find 2 highest sal from each dept who have completed 5 year in org

Wipro,

1677

if collect stats but it show low confidence why?

IBM,

1 1755

can anyone suggest best free Talend data integration training online

1 1761

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1 1560

Un-Answered Questions { Data Warehouse }

Hi friends, what are the new features in abinito3.0?

2860

how to generate the test data in sas without input data? : Sas-administrator

1202

Hi, If anyone has base SAS certification dumps, please share.

1937

How do you remove duplicate records in informatica? And how many ways are there to do it?

1232

What r the names of the reports that you prepared?

1029

Write the unconnected lookup syntax and how to return more than one column.

1174

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2766

hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2299

Write the unconnected lookup syntax?

1146

What is dimensional table? Explain the different dimensions.

1267

What is a rollup component? Explain about it.

1242

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1196

draw informatica architecture 8.6 ?

3945

explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4192

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2436

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