Answer / gopal

Collection of multiple fact tables surrounded by dimension is called galaxy or multistar or fact consultaion Schema.

Answer / b.indu

A combination of star schema and snow flake star schema is known as galaxy schema

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

what are challenges that you faced in testing? give solution to it?

1 Answers  

---

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

9 Answers   Deloitte,

---

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

---

Which files are created during the session rums by informatics server?

0 Answers  

---

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

---

If informatica has its scheduler why using third party scheduler?

0 Answers  

---

what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,

---

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  

---

what is the difference between onsite & client site?

1 Answers  

---

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

---