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 2767

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,

1511

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

IBM, Saama Tech, Wipro,

1 1897

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

IBM, Saama Tech, Wipro,

1264

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

IBM, Saama Tech, Wipro,

1194

How to delete data which is not in source table?

IBM, Saama Tech, Wipro,

1336

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

IBM, Saama Tech, Wipro,

1 2432

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 3791

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

Cap Gemini,

1 2909

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,

1376

On which transformations you created partitions in your project?

Cap Gemini,

1348

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

Wipro,

1609

if collect stats but it show low confidence why?

IBM,

1688

can anyone suggest best free Talend data integration training online

1690

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?

1497

Un-Answered Questions { Data Warehouse }

Why null values are mapped as 0 in fact tables?

1004

How can you define user defied event?

1031

Performance tuning( what you did in performance tuning)

1987

How can we use external procedural logic in informatica?

924

What is the function that transfers a string into a decimal?

1156

Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

2763

How do you load only null records into target?

1216

How to export mappings to the production environment?

908

What is cluster AWS cloud?

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

1090

What is etl process? How many steps etl contains?

1034

Can informatica load heterogeneous targets from heterogeneous sources?

1187

what is the difference between == and eq in UNIX shell scripting?

1500

What is repository manager?

989

how to create cubes in transformer ?

1073

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