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
- 13444 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 pmrep command?
What are the differences between sql override and update override?
How etl testing is different from database testing?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in
how would u estimate the size of Lookup transform data and index cache?
What is lookup table in etl testing?
how do u identify the changed records in operational data?
Is apache nifi an etl tool?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
What is the difference between Data Warehousing and Data Mining?
In Which Transformation We Can Use Having Clause In Informatica?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
Which transformation we use to convert 'NA' to 'Not Available'
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
