IN Informatica, I have 10 records in my source system. I need to load 2 record

IN Informatica, I have 10 records in my source system. I need
to load 2 records to target for each run. how to
perform.please let me know. I know by using Mapping variable
we can perform but how to load please any one explain.

Question Posted / janardhan

3 Answers
13451 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each..

Answer / dev

v_filter and v_min_filter
are the variable port how these port come to filter
transformation by which u will compair it on filter
transformation plez check it i need ur help and send me at
hotadebadatta2008@gmail.com

Is This Answer Correct ?

0 Yes

0 No

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each..

Answer / ankit kansal

Overall Desc
SRC-->>SQ-->>EXPR-->>FILTER-->>TARG

create a mapping variable name $$max_bound of integer data type and aggregation type max

now in expression variable
seq v seq+1
o_seq o seq
v_temp v v_temp+1
curr_val v IIF(v_temp=1,setmaxvariable($$max_bound,$$max_bound+2),0)
o_map_val o setvariable($$max_bound,NULL)

now come to filter transformation
and write condition as
(seq<=$$max_bound)AND(seq>$$max_bound-2)

Thanks
http://deepinopensource.blogspot.in/

Is This Answer Correct ?

0 Yes

0 No

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each..

Answer / naveen

You are right , this can be achieved only with the help of
the mapping variable. and also a filter transformation

1) create a mapping variable and assign a default value 0
2)during the first run , i hope ur source must have an seq
num in it, if not use the seq gen and have unique sorted
record.
3)in a n expression , just have v_max_filter =
@@map_variable + 2 and v_min_filter = @@map_variable - 2

4) in the filter transformation , put the filter on the
seq_column <= v_filter and seq_column >= v_min_filter

5) enjoy a coffe, this will run

Is This Answer Correct ?

4 Yes

6 No

Post New Answer