Answer / suresh

SQ ==> select rownum as num,col1,col2,.. from table
FLT ==> num >= MVar1 and num <=MVar2

Mvar1 and MVar2 are assigned with the value of 1 and 10 respectively

in EXP=>V-port - setvariable(mvar1, 10)
V-port - setvariable(mvar1, 20)

after the execution of the mapping 10 and 20 values are stored in the mvar1 and mvar2 into the repository

Answer / santosh

1. Create a mapping variable $$SESSION.
2. Link from SQ to Router t/r.
3. Create two group
a. SETMAXVARIABLE($$SESSION,$$SESSION+1) % 2 = 1
b. SETMAXVARIABLE($$SESSION,$$SESSION+1) % 2 = 0
4. Link both group to two filter and create two Sequence geneter and check the reset option.
5. Link the sequence generator to filter t/r.
6. Keep the condition as "NEXTVAL<=10" for first filter.
7. Keep the condition as "NEXTVAL>10" for second filter.
8. Link the two filter to two different target instance.

Let me know if any things wrong.

Thanks & Regards
Santosh Kumar Sarangi

Answer / babu

Hi,
If u r source is Relational,then u can write sqloverride.
i.e
SQ ==> select rownum as num,col1,col2,.. from table
FLT ==> (num >= MVar1 and num <=MVar2)

NOTE: MVar1,MVar2 are mapping variables the initial values
of these variables 1,10 with respectivelly.

after completion of firsst run the variables are increased
11,20 respectivelly.all are knows how to declare the
mapping variables.
IF THERE IS ANY WRONG PLEASE CORRECT ME.

Thanks,
Babu

Explain in detail about scd type 1 through mapping.

0 Answers  

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

can u any challenge your project?

0 Answers   HP,

---

How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,

---

How can we use mapping variables in informatica?

0 Answers  

---

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

---

daily how much amount of data send to production?

4 Answers   HSBC,

---

Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  

---

how to run workflow in unix?

5 Answers   Colgate, HP, Tech Mahindra,

---

what are presession,postsession success and postsession failure commands ?

1 Answers  

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---