Answer Posted / rahul

follow the below stepd to tune the joiner t/r ( which i
know)
1. select sort input and make sure that you send the sorted
data.
2. try to use normal join and master join than full and
detail join.
3.try to mark the master table which has less no.of rows

What will be the approach?

929

---

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

8126

---

Explain joiner transformation in informatica

1073

---

What are the differences between source qualifier and joiner transformation?

992

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2677

---

What is session task and command task?

1176

---

Is stop and abort are same in informatica?

947

---

update strategy transformation in informatica

1014

---

What is decode in static cache?

1078

---

What does cheating measurement mean?

995

---

How do we call shell scripts from informatica?

1011

---

explain one complex mapping with logic? sales project?

6592

---

What are the reusable transformations?

1097

---

What does “tail –f” command do and what is its use as an Informatica admin.

1029

---

In informatica workflow manager, how many repositories can be created?

1267

---