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
- 13751 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
what is a worklet?
How to fine tune mappings?
where are the log files generally stored.Can you change the path of the file.what can the path be?
What is etl process. How many steps etl contains explain with example?
how would u estimate the size of Lookup transform data and index cache?
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 ?
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 to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Explain about hash partitioning?
what is the difference between cardinality and Nullability?
what happens if the info.server doesn't find the session parameter in the parameter file?
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
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
Compare etl & elt?
