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
- 11517 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 powercenter on grid?
Explain informatica architecture - version 8 / 9
While migrating the data from one environment to another environment how would you manage the connections?
On which transformations you created partitions in your project?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is Cognos script editor?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
tell me about your project functionality
Differentiate between source qualifier and filter transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to load the data from people soft hrm to people soft erm using informatica?
difference between repository database and repository service?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the way to execute pl/sql script using informatica mapping?
