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
- 11334 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
What is resilience time?
How do you load first and last records into target table?
Can we create multiple integration service on single repository?
Explain the code page compatibility?
How does a rank transform differ from aggregator transform functions max and min?
what is degenerated dimension?
Is it possible to revert a global repository to local one and why?
What is the way to execute pl/sql script using informatica mapping?
What are the uses of etl tools?
What is data transformation manager process?
According to his methodology what all you need before you build a datawarehouse
Explain the etl program with few examples.
How would you join a node to the already existing domain?
Write the program through which the records can be updated?
Clarify the aggregator change?
