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 is etl tool in hadoop?
In Which Transformation We Can Use Having Clause In Informatica?
how many steps are there in etl process?
What is the difference between Data Warehousing and Data Mining?
Explain about round-robi?
Explain about enterprise scalability and roi of data integration suite?
what is pmrep command?
what are Lookup caches options? Including persistent caches.
what is the difference between cardinality and Nullability?
what is the difference between cardinality and Nullability?
What is abap? What are idocs?
how does the server recongnise the source and target databases.Elaborate on this
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
what is Forward,Reverse and Re_engineering?