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

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

---

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

---

What are the out put files that the informatica server creates during the session running?

2 Answers  

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,

---

Explain the pipeline partition with real time example?

0 Answers   Informatica,

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

5 Answers   TCS,

---

how to obtain performance data for individual transformations.

2 Answers  

---

What is a command that used to run a batch?

2 Answers  

---

what is parameter file?

1 Answers   Cap Gemini,

---

Differentiate between sessions and batches?

0 Answers  

---