Answer Posted / ram mohan reddy

we can do this process by 2 ways ....
1)by dynamic lookup option in lookup(new lookup row) we can
load duplicate rows in one target table and unique rows in
one target table
do to this we need to have router transformation (add to
group ports one is for unique(new lookup row=1) and other is
for duplicate(new lookup row =2))after the lookup trans.
2)we can perform this by aggregator transformation using
coutnt(*) >1 for duplicate rows .here also we need to use
router transformion.

What is a rank transform?

1146

---

What is a passive transformation?

1153

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2349

---

What is meant by LDAP users?

1288

---

What are the types of caches in lookup?

1095

---

what are the deliverables?in your project?

2194

---

Differentiate between joiner and lookup transformation?

1159

---

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2184

---

How can we handle two sessions in informatica?

1092

---

What is the procedure for creating independent data marts from informatica 7.1?

1118

---

What is the difference between source qualifier transformations source filter to filter transformation?

1096

---

What are the advantages of using informatica as an etl tool over teradata?

1073

---

Do you find any difficulty while working with flat files as source and target?

1147

---

What is meant by pre and post session shell command?

1200

---

can anyone suggest best free Talend data integration training online

1744

---