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.

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2341

---

what is degenerated dimension?

3998

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1581

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1080

---

Is stop and abort are same in informatica?

1002

---

explain abt ur project architecture?

2195

---

How many dimensions are there in informatica?

1091

---

where to store informatica rejected data?

1093

---

Explain joiner transformation in informatica

1124

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1781

---

What is status code in informatica?

1021

---

In informatics server which files are created during the session rums?

1115

---

What is event and what are the tasks related to it?

1122

---

Explain the different dimensions.

967

---

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

1086

---