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

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  

---

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,

---

What is diff joiner and lookup

4 Answers   BirlaSoft,

---

What is sequence generator transformation in informatica?

0 Answers  

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---

list out all the transformations which use cache?

0 Answers   Informatica,

---

how to remove staging area

1 Answers  

---

how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,

---

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

---

What are the types of lookup?

3 Answers   Wipro,

---

how to connect two or more table with single source qualifier?

4 Answers   IBM,

---