Answer Posted / santosh kumar sarangi

1.Take a sequence generator and connect it to the expression
t/r.
2.In expression transformation create a out put post and
keep the below condition;
VAL_OUT = iif(mod(floor((nextval-1)/10),2)=0,0,1)
3.Keep a router t/r, and filter with the condition VAL_OUT=0
then first target and if VAL_OUT=1 then second target.

Let me know if any thing wrong.

Thanks & Regads
Santosh Kumar Sarangi

What is informatica? Why do we need it?

1162

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

2004

---

What do think which one is the better joiner or look up?

1242

---

Explain the difference between mapping parameter and mapping variable?

1078

---

What are the components of the workflow manager?

1179

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7232

---

How to update or delete the rows in a target, which do not have key fields?

1219

---

Explain what are the different types of transformation available in informatica.

1244

---

What is Session and Batches?

1147

---

How to partition the Session?

1149

---

define galaxy repository in informatica

2285

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2399

---

Explain the aggregator transformation?

1219

---

What are session parameters ? How do you set them?

1899

---

How can you validate all mappings in the repository simultaneously?

1421

---