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.

server hot-ws270 is connect to Repository B. What does it mean?

2462

---

What is the use of transformation?

959

---

What is transformation?

1061

---

What is informatica metadata and where is it stored?

948

---

What is the difference between Active and Passive transformation?

1096

---

can we override a native sql query within informatica? Where do we do it?

1080

---

Under what condition selecting sorted input in aggregator may fail the session?

1077

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1280

---

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

2068

---

Explain sql transformation in script mode examples in informatica

1065

---

Explain incremental aggregation in informatica

1084

---

Why is sorter an active transformation?

1066

---

What are connected or unconnected transformations?

1058

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7288

---

How do you migrate data from one environment to another?

1057

---