Answer Posted / adithya amanchi

Router transformation is all about dividing data into group
of records based on one or more conditions. For example,
assuming a building as table with 10 floors considering each
floor as a record. The first three floors are for parking,
next three are for cinema halls and rest are for shopping.
It is nothing but making a vertical table into pieces.

Joiner transformation is nothing but depending upon common
columns(attributes or fields) or primary and foreign key
relationship combining two or more tables horizontally.
Making the table wider. similar to above example, joining
two buildings of different floors making one side of each
building as common.


hope this will help you guys

When do you use sql override in a lookup transformation?

1099

---

Different circumstance which drives informatica server to expel records?

984

---

what is the hint? how to use it to reduce the query processing in program?

7838

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2159

---

How to create a non-reusable instance of reusable transformations?

1135

---

tell me 5 session failure in real time how can you solve that in your project?

2305

---

How to do the error handling of if ur source is flatfiles?

1968

---

How to create the source and target database connections in server manager?

1090

---

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

1066

---

What is workflow manager?

1050

---

What are the performance considerations when working with aggregator transformation?

1153

---

How can we improve session performance in aggregator transformation?

1117

---

How does the aggregator transformation handle null values?

1149

---

How can you define user defied event?

1031

---

Explain target update override in informatica

1126

---