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
- 13620 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain about etl data integration software?
what happens if the info.server doesn't find the session parameter in the parameter file?
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.
What is fact? What are the types of facts?
What is a mapping?
How to fine tune mappings?
What is meant by incremental load?
What is etl process. How many steps etl contains explain with example?
What is the difference between round-robin partitioning and hash partitioning?
What is data cleaning?
What are the key benefits of ETL Testing?
What is the difference between Data Warehousing and Data Mining?
What is full load & incremental or refresh load?
What are the names of the layers in etl?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
