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

what is the difference between cognos8 fm and cognos reportnet fm?

1 4904

does query is created for date prompt?

9 11745

what is the use of layout calculation?

4 17422

what is the difference between cascading prompt and drill-thru

4 13316

1)How to do error handling in datastage? 2)Did sequential stage accepts .xl files ,xml? znd how?

UHG,

2 14145

1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?

CTS, HCL, IBM, Wipro,

6 32586

What is Merging, Segments and porting in Framwork Manager?

Nike,

3 12425

Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K

Accenture, IBM, TCS,

6 11912

hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

TCS,

1 2450

what is the need of INDEX in datasets?

CitiGroup,

6 14155

tell me about intnx, intcx functions?

CitiGroup,

4 23176

what is Global Symbol table and Local symbol table?

CitiGroup,

4 19988

how to assign a macro value to a variable?

CitiGroup,

8 16944

describe about joins? briefly?

CitiGroup,

2 7340

how to write code for left outer join in SAs using datastep?

CitiGroup,

8 21850

Un-Answered Questions { Data Warehouse }

EXL informatica Questions

1459

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

2432

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

4191

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

1936

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2167

can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance

2306

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1199

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 ?

2546

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..

2765

what are the data modeling tools you have used?(polaris)

2057

Explain how to generate iqd file from framework manager?

1020

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1041

What sort of existing documents should business analysts refer to when starting on a new project?

1078

Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you

1769

Explain about a tricky situation for which you found a very simple solution?

1077

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