Interested to Buy Any Domain ? << Click Here >> for more details...
Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
- 5 Answers
- 11306 Views
- Flextronics, I also Faced
- E-Mail Answers
Answer Posted / joe
We cannot use a sorter because it will shuffle the data.
For the last 20 rows. In a seperate pipeline use aggregator
and do a Count(key) and Max(key) to get the total number of
rows.
use an output port o_count and o_max to populate this count
to an expression transformation before the Filter.
o_count_last_20 = o_count - 20
i.e. if there are 35 records we need records from 15 to 35
In the filter check nextval between o_count_last_20 and
o_Max
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Performance tuning( what you did in performance tuning)
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is status code in informatica?
What are the uses of etl tools?
What is the Process to creating lookup transformation in informatica
Is it possible to use a client with different version than that of its Informatica server?
How are indexes created after completing the load process?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
is it possible to index the data in cache of lkp transformation ?
What is the use of code page?
What is a shortcut and copy in Informatica and how two are different with each other?
What is Data Caches size?
can we override a native sql query within informatica? Where do we do it? How do we do it?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a mapplet/worklet in informatica?
