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

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

---

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

---

What are the active and passive transforamtions?

2 Answers  

---

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  

---

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 Answers  

---

Informatica settings are available in which file?

0 Answers   Informatica,

---

What is a taget load order?

2 Answers   IBM,

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers  

---

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

---

What are conformed dimensions?

1 Answers  

---

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

How are indexes created after completing the load process?

0 Answers  

---