Answer Posted / mike

If you create two groups in the router transformation and
you want to load the records in to two target tables then

src-->srcq--->router-->/t1
\t2..The records which meet the
condition in the first group will pass in to the T1 and the
records which meet the condition in the second group will
pass in to the T2...i mean to say all the records that
matches the condition will come as an output


correct me if i was wrong

Define the various join types of joiner transformation?

763

---

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

1866

---

Can you generate sequence numbers without using the sequence generator transformation?

816

---

Enlist few areas or real-time situations where informatica is required.

808

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

832

---

What is the surrogate key?

848

---

What is the sequence generator transformation in informatica?

852

---

design of staging area?

1799

---

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

913

---

What is update strategy transform?

796

---

What are the components of the workflow manager?

878

---

What are the types of data warehouses?

1166

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

884

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1656

---

Mention a few design and development best practices for informatica?

740

---