Answer / durgaprasad

data flow for this one is:

sq-->Aggregater-->Router-->target

in aggregater t/r take 2 output ports and give condition like

uniqe_port---->count(*)=1

duplicate_port--->count(*)>1

connect this one router and in router take 2 groups and
give condition like

uniqgroup=uniqe_port

duplicategroup=duplicate_port


and connect that groups to target

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

---

Without using any transformations how u can load the data into target?

15 Answers   IBM,

---

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---

how to get the first row without using rank t/r?

7 Answers   iGate,

---

What is a rank transform?

0 Answers  

---

how will u get 1 and 3rd and 5th records in table what is the query in oracle please help me

16 Answers   Cap Gemini, IBM,

---

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 Answers  

---

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

---

What is the default source option for update stratgey transformation?

1 Answers  

---

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers   HP,

---

I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  

---