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

Explain what is the difference between microstrategy and cognos reporting tool?

1079

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1090

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1132

Explain what is informatica metadata and where is it stored?

1053

How to use procedural logic inside infromatica?

1250

What is informatica metadata and where is it stored?

995

How to call shell scripts from informatica?

1001

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1106

Is there any way to read the ms excel datas directly into informatica?

1026

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1061

Explain the different lookup methods used in informatica?

1049

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1022

Explain what are the different versions of informatica?

1102

How to extract sap data using informatica? What is abap? What are idocs?

1186

What are the different versions of informatica?

1279

Un-Answered Questions { Data Warehouse }

How to load last n records of file into target table - informatica

1083

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

2368

What is a node in teradata? Explain

1014

How to read multiple files using a single datastage job if files have the same metadata?

1253

What are the types of containers in datastage?

1193

Mention what is a partition and what are the different types of partition components in abinitio?

1187

How can we do data cleaning?

1067

What are the scenarios in which full table scans occurs?

1011

what are the devoleper roles in real time? plz tell i am new to datastage....

2164

Explain why denormalization is promoted in universe designing?

962

What are the components new in 2.14 compared to 1.8 and State the usage of the components?

2224

what are _numeric_ and _character_ and what do they do? : Sas programming

1159

How many sessions of MAX is PE capable of handling at a particular time?

1085

what is the difference between floor and ceil functions in sas? : Sas-administrator

1265

Under which circumstances, informatica server creates reject files?

1102

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