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

0 Answers  

---

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 Answers  

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

---

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

---

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

---

---

Which are the different editions of informatica powercenter that are available?

0 Answers  

---

By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

What is mapplet in informatica?

0 Answers  

---

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

---