Answer Posted / bala

substr(col_name,10,5)

What is meant by lookup transformation? Explain the types of lookup transformation?

1022

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1140

---

What is meant by lookup transformation?

1182

---

What is flashback table ? Advance thanks

1998

---

Describe expression transformation?

1170

---

How to go to the older version for a mapping?

1159

---

How can you increase the performance in joiner transformation?

1248

---

Explain what are the different types of transformation available in informatica.

1248

---

How many ways are there to do 'remove duplicate records in informatica'?

1065

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2191

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2350

---

What is the benefit of session partitioning?

1157

---

What is resilience time?

1227

---

What are the differences between a connected lookup and unconnected lookup?

1125

---

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

1958

---