Answer Posted / ankit kansal

Using Informaica

src-->>sq-->>rnk(sal,bottom,1)
-->>union-->>tgt
src-->>sq-->>rnk(sal,bottom,1)


http://deepinopensource.blogspot.in/

How to join three sources using joiner? Explain though mapping flow.

1190

---

What is primary and backup node?

1174

---

What are the limitations of joiner transformation?

1177

---

What are some examples of informatica etl programs?

985

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7235

---

How does the aggregator transformation handle null values?

1193

---

Define mapplet?

1059

---

what are 3 tech challenges/ common issues you face?

2395

---

is it possible to index the data in cache of lkp transformation ?

2076

---

What is the difference between informatics 7x and 8x and what is latest version?

1137

---

What is the reusable transformation?

1101

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1556

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2312

---

What is resilience time?

1227

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1956

---