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

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,

---

What are the mapping paramaters and mapping variables?

1 Answers  

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  

---

---

How/where can i install Informatica software with oracle or teradata as database

0 Answers  

---

What are the types of lookup?

3 Answers   Wipro,

---

In operator is used in which transformation in informatica 8.6.0

5 Answers   Virtusa,

---

Enlist the advantages of informatica.

0 Answers  

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

Difference Between ETL & ELT?

1 Answers   TCS,

---

I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,

---