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.
Answers were Sorted based on User's Feedback
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 |
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 |
What is data cleaning?
how do u really know that paging to disk is happening while u are using a lookup transform?
When do we analyze the tables?
Explain do we need an etl tool? When do we go for the tools in the market?
what are Lookup caches options? Including persistent caches.
What is cube grouping?
flat filevalidation in informatica
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
explain the methodology of Data Warehousing?(Polaries)
Need Informatica Power Center 9.1 free download(for all windows version)
State the differences between shortcut and reusable transformation
what are the concerns of OLTP and DSS systems?