Answer Posted / bala ramesh

in this logic , frist take one sequene genrator
transformation ,pass next value to expression
transformation and also pass id,name,and amt.
in this transformation and also create one output port
(temp).it is decimat type and write codition like
(iif(NEXTVAL %2=0,0,1)) , after take one router
transformation ,pass these ports (id,name,amt and
temp) .then create two group ,one is temp=0 and another one
is temp=1.after pass first group to one flat file ,second
group to second flat file.

How to update source definition?

1076

---

which one is better performance wise joiner or look up

1073

---

How can we update a record in the target table without using update strategy?

1123

---

What is the status code in stored procedure transformation?

1167

---

What is deployment group?

1186

---

Explain Dataware house architecture .how data flow from intial to end?

2574

---

What are the new features of informatica 9.x in developer level?

975

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1974

---

wat are deployement groups in informatica, how it will be used for developers

1701

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2022

---

What is standalone command task?

1306

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1087

---

What is the Process to creating lookup transformation in informatica

1032

---

How can a transformation be made reusable?

1145

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2054

---