Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 13597 Views
- TCS, I also Faced
- E-Mail Answers
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 reports developed in sap bw project and what is the requirement for developing it?
What is lookup table in etl testing?
Explain different types of partitioning?
how many maximum session supports to multiload in teradata ??
Explain do we need an etl tool? When do we go for the tools in the market?
What is full load & incremental or refresh load?
what is data modeling?
What is cube grouping?
what is the difference between cardinality and Nullability?
What are the modules in Power Mart?
What are the three tiers in etl?
Explain the key challenges that you face while performing etl testing.
What is a mapping?
can cubes contain measures ?
dimension object created in oracle can be imported in designer?how?
