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 persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2315

---

What is the function of union transformation?

1125

---

Implementation methodology

1705

---

What is the way to execute pl/sql script using informatica mapping?

1595

---

How might you approve all mappings in the archive all the while?

1014

---

Explain sessions. Explain how batches are used to combine executions?

1024

---

What is parallel processing in informatica?

1706

---

What is informatica metadata and where is it stored?

989

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1998

---

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

9109

---

How to load data in informatica ?

999

---

What is the need for an etl tool?

1064

---

Explain the types of lookup transformation?

1041

---

In informatica workflow manager, how many repositories can be created?

1348

---

What are the different ways to implement parallel processing in informatica?

1422

---