Answer Posted / kumar

replacestr function won't work for characters larger than 65535.

https://etltechsolutions.wordpress.com/2016/05/11/error-message-is-replacestr-data-too-large/

and

https://network.informatica.com/thread/3080

What is a joiner transformation and why it is an active one?

1080

---

How to load last n records of file into target table - informatica

1081

---

without table how to come first record only in oracle?

2253

---

Which is the t/r that builts only single cache memory?

1190

---

How do you promote a non-reusable transformation to reusable transformation?

1138

---

What are the prerequisite tasks to achieve the session partition?

1252

---

What will be the approach?

979

---

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

1910

---

How to generate sequence numbers without using the sequence generator transformation?

1206

---

Define mapplet?

1009

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2298

---

What are the issues you have faced in your project? How did you overcome those issues?

2365

---

How to call shell scripts from informatica?

997

---

What is dimensional table? Explain the different dimensions.

1172

---