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
- 11106 Views
- Flextronics, I also Faced
- E-Mail Answers
Answer Posted / raju
You can also achieve using following flow in the mapping.
1)Create an out put port SNO in expression transformation
and connect it to NEXTVAL port in sequence generator
transformation.
2)Use sorter transformation.In sorter ,use SNO port as key
column and Direction is Descending.
3)Use filter transformation with filter condition as
SNO<=20.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How to create Target definition for flat files?
Describe data concatenation?
How to join three sources using joiner?
How many ways are there to do 'remove duplicate records in informatica'?
Explain sessions?
complex mapping ur project u r invlve can u explain and give real time example give me ?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Briefly define a session task?
What is the difference between source qualifier transformations source filter to filter transformation?
explain abt ur project architecture?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is a filter transformation?
define galaxy repository in informatica
