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
- 13475 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / naveen
You are right , this can be achieved only with the help of
the mapping variable. and also a filter transformation
1) create a mapping variable and assign a default value 0
2)during the first run , i hope ur source must have an seq
num in it, if not use the seq gen and have unique sorted
record.
3)in a n expression , just have v_max_filter =
@@map_variable + 2 and v_min_filter = @@map_variable - 2
4) in the filter transformation , put the filter on the
seq_column <= v_filter and seq_column >= v_min_filter
5) enjoy a coffe, this will run
| Is This Answer Correct ? | 4 Yes | 6 No |
Explain different types of partitioning?
What are your responsibilities as an etl tester?
How can we use external procedural logic in informatica?
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
what is meant by drill through?(Mascot)
how do u decide whether u need to do aggregations at database level or at Informatica level?
What is fact? What are the types of facts?
how would u estimate the size of Aggregator transform data and index cache?
how do u implement configuration management in Informatica?
please tell me any easy ways of testing the Data warehouse project. In my project we are not using any tools for ETL. we are writing scripts in SCRIPTELLA. And we using Pentaho tool for Reporting How can i test all these. please tell me ASAP. thanks in adavance
how do u really know that paging to disk is happening while u are using a lookup transform?
How we can see table structure?
Teradata 
