Data Warehouse Interview Questions
Questions Answers Views Company eMail

which r the connectors used in san?

1788

what is the generated prompt,how can i use?

5 18039

how much memory space occupied real time project (roughly)?

1801

What is mean by tuning the report?

1 2476

what are they different types of report in BO?

6 30418

How do scheduling the report in BO XIR2? can you say what are they steps?

5 10207

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 25327

I am currently pursuing a career in Cognos and need your support in the same regard. I am in the position that you were in as described above. I would like you to share your experience during interviews, project explanation, on the job etc. I am preparing for the interviews and am quite nervous about cracking it. I am sure you understand the anxiety. Your help will be greatly appreciated. Awaiting your response!

3 8469

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

BirlaSoft,

5 13444

What are set operators in Oracle

Deloitte, Wipro,

3 15824

How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this

Deloitte,

9 16627

from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic

Deloitte,

21 34072

why sequence generator should not directly connected to joiner transformation ?

ANZ,

1 9799

What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?

1 4377

What is Target Update Override? What is the Use ?

Patni,

8 16851


Un-Answered Questions { Data Warehouse }

Explain joiner transformation in informatica

667


Difference between b.o 5.1 and 6.1b?

651


What is smart metric?

543


Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

1807


What are some primary characteristics of teradata?

551






What is dimensional modelling?

522


define galaxy repository in informatica

1727


What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

605


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

551


what is the difference between querystudio in reportnet and cognos8

1735


What is the difference between check point and phase?

682


How is security handled?

581


What is level prompt?

532


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

7767


Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

704