Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
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 are the different components of powercenter?
How to open an older version of an object in the workspace?
Differentiate between Load Manager and DTM?
Explain the use of aggregator cache file?
What is enterprise data warehousing?
What is dimensional table? Explain the different dimensions.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is informatica etl tool?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain the different lookup methods used in informatica?
Explain what is informatica metadata and where is it stored?
What is a code page?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is informatica worklet?
Explain informatica architecture - version 8 / 9