Answer Posted / abhishek

When the Integration Service processes a Joiner transformation, it reads rows from both sources concurrently and builds the index and data cache based on the master rows. The Integration Service then performs the join based on the detail source data and the cache data.

The number of rows the Integration Service stores in the cache depends on the partitioning scheme, the source data, and whether you configure the Joiner transformation for sorted input.

To improve performance for an unsorted Joiner transformation, use the source with fewer rows as the master source. To improve performance for a sorted Joiner transformation, use the source with fewer duplicate key values as the master.

What are the tasks that can be performed using sq?

1093

---

Implementation methodology

1714

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1946

---

What does update strategy mean, and what are the different option of it?

1092

---

What is the Process to creating lookup transformation in informatica

1046

---

What are the settings that you use to configure the joiner transformation?

1055

---

How to partition the Session?

1113

---

What is complex mapping?

1122

---

What is a difference between complete, stop and abort?

1083

---

How to do unit testing in informatica?

1173

---

What is sorter transformation?

1048

---

Explain load alternative records / rows into multiple targets - informatica

1153

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1086

---

Explain what transformation and how many are there in informatica?

958

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

---