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

What is the Difference between DSS & OLTP?

5 Answers  

---

What are the methods for creating reusable transforamtions?

2 Answers  

---

what is hash table in informatica?

1 Answers   Zensar,

---

what is constraint based loading

2 Answers   IBM,

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

---

What are the transformations that are not supported in mapplet?

0 Answers  

---

what is distinct

4 Answers  

---

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

---

i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 Answers  

---

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

---

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers  

---

Define the various join types of joiner transformation?

0 Answers  

---