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.

What do you understand by term role-playing dimension?

1048

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1767

---

What are the tuning techniques you applied during your last project

2026

---

What is an active transformation?

1110

---

Explain how to import oracle sequence into informatica?

1011

---

What is the commit type if you have a transaction control transformation in the mapping?

1030

---

What is option by which we can run all the sessions in a batch simultaneously?

1142

---

What are the static cache and dynamic cache in informatica?

1192

---

What could be the possible resons of locks by user?

1094

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7391

---

How do you load first and last records into target table?

1159

---

Explain lookup transformation in informatica

1073

---

How many ways are there to create ports?

1332

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1171

---

What are the tasks that can be performed using sq?

1091

---