Answer Posted / anup shukla

Create router transformation with 4 different ports.
and set condition true for all the four ports.



and take it to the target from union trans.

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1681

---

How can you differentiate between powercenter and power map?

620

---

Different circumstance which drives informatica server to expel records?

549

---

As union transformation gives UNION ALL output, how you will get the UNION output?

639

---

whats the logic to load the lower level of granularity of data to fact table.

1789

---

---

What are connected or unconnected transformations?

625

---

What is an Integration service in Informatica?

699

---

difference between informatica 8.1.1 and 8.6

3236

---

How to update source definition?

626

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

1802

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1316

---

Explain pushdown optimization $pushdownconfig parameter - informatica

697

---

What are roles and groups and benefits of using them?

569

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

1757

---

What does reusable transformation mean?

670

---