Answer Posted / abidu

Connect the ports of the filter transformation to the
second target table and enable the 'FORWARD REJECTED ROWS'
in the properties of the filter transformation. the
rejected rows will be forwarded to this table.

pls let meknow if i m wrong anywhere.

What is mapplet in informatica?

1129

---

What the difference is between a database, a data warehouse and a data mart?

1203

---

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

1962

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3755

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1168

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1200

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2481

---

How do you handle two sessions in Informatica

1221

---

What can we do to improve the performance of informatica aggregator transformation?

1147

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1341

---

What is domain and gateway node?

1208

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2325

---

What is a node in Informatica?

1087

---

What is repository manager?

1028

---

Describe expression transformation?

1170

---