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
- 12932 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 an ETL or ETT? And what are the different types?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Identifying the bottlenecks in various components of Informatica and resolving them.
what is session partitioning?
What are dimensions?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What are the different etl testing categories as per their function?
what are the facilities provided by data warehouse to analytical users?
how to connect to a flatfile through ftp in informatica
hoe to access second value in mapping parameter if it is having more than one value ?????????????
What is tracing level? How many types of transformations supported by sorted input?
What are the three tiers in etl?
Do we need an ETL tool? When do we go for the tools in the market?
What are cubes and olap cubes?
