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.
Answer Posted / 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 |
Post New Answer View All Answers
What are the names of the layers in etl?
How etl testing is different from database testing?
What is grain of fact?
what is pmrep command?
tell me few points when u become TL
What are the various tools used in etl?
dimension object created in oracle can be imported in designer?how?
What is tracing level? How many types of transformations supported by sorted input?
how would u estimate the size of Aggregator transform data and index cache?
What is fact? What are the types of facts?
what are the types in error loging?
what do u do when DB time takes more?in sap bi
What is abap? What are idocs?
Which transformation we use to convert 'NA' to 'Not Available'
How to increase performance without changing anything in mapping.( In prod)