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
- 13619 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 is lookup table in etl testing?
What is tracing level? How many types of transformations supported by sorted input?
Can there be sub steps of etl steps?
Two default user groups created in the repository are____and_____.
what is Forward,Reverse and Re_engineering?
What is a lookup table in etl?
when will use SQL override in a lookup transformation?
Explain about etl data integration software?
flat filevalidation in informatica
how to connect to a flatfile through ftp in informatica
What is etl process. How many steps etl contains explain with example?
Explain the use lookup tables and Aggregate tables?
What are materialized views & where do we use them?
what are the session parameters? How do u set them?
what are the types in error loging?
