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.
Answer Posted / 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 |
Post New Answer View All Answers
what happens if the info.server doesn't find the session parameter in the parameter file?
List few etl bugs?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Explain about power designer data modeling software?
what is session partitioning?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
can be used COM component in Informatica ?
What is meant by incremental load?
How etl testing is different from database testing?
what is dynamic insert?
how do u set partition points in the mapping?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Define Dynamic push down optmization?