Answer / prasuna

You can improve session performance by configuring the
Joiner transformation to use sorted input.

To configure a mapping to use sorted data, you establish and
maintain a sort order in the mapping so the Integration
Service can use the sorted data when it processes the Joiner
transformation.

Answer / x

Hi,

In joiner T/S properties we have an option called sorter
input.
So by using this we can improve the session Performance

Answer / rakesh

while using the option sorted input, we must have to use sorter t/r before joiner to send the sorted data to the joiner.

Answer / m

To improve the perfomance we have to check the button "sorted input" ,

Answer / sreekanth

to eliminate duplicates also sorter transformation is used

define galaxy repository in informatica

0 Answers  

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

Explain the types of lookup transformation?

0 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

How will the document be delivered to me?

0 Answers  

---

---

what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,

---

What is router transformation

4 Answers   CSC,

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

---

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---

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

6 Answers   HSBC,

---

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  

---