Answer / hari

. Aggregator Transformations
. Sorter Transformations
. Custom Transformation
. External Procedure Transformation
. Filter Transformation
. HTTP Transformation
. Java Transformation
. Joiner Transformation
. Lookup Transformation
. Normalizer Transformation
. Rank Transformation
. Router Transformation
. Sequence Generator Transformation
. Expression Transformation
. Sorter Transformation
. Source Qualifier Transformation
. SQL Transformation
. Stored Procedure Transformation
. Transaction Control Transformation
. Union Transformation

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

---

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,

---

if i have one mapping and we already tuned that mapping for performance,everything is fine and loading will take 1 hr,so without doing any change in mapping how could we reduce the loading time from 1hr to 1/2 hr.

5 Answers   Wipro,

---

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

How to join three sources using joiner?

0 Answers  

---

why union is active transformation?

4 Answers   IBM,

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

How to delete duplicate records in a flat file source?

2 Answers  

---

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,

---

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

---