Answer / venkatesh

by using aggrigator transformation we can eliminate
duplicate records in informatica
The flow will be like this

source--->aggrigator----->target

in aggrigator group by all ports then the out put is only
unique records
connect it to the target
2)we can do it by sorter also in sorter if we enable select
distinct then it will gives unique row
3)if u r source is database then u can select distinct in
sourcequalifier it self

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

what is a transforamation?

5 Answers  

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

---

Which files are created during the session rums by informatics server?

0 Answers  

---

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,

---

what type of transformation is not supported by mapplets?

4 Answers   CTS,

---

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

---

what is mystery dimension?

1 Answers  

---

what is confirmed fact?

2 Answers  

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---

What are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

---