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
- 11307 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
explain about unit testing? in real time?
waht type of interface is used for testing the data in informatica
4 yrs etl devloper roles and responsibilities?any body give solutions
What is the way to execute pl/sql script using informatica mapping?
my source is junk data how will u remove that junk data by using unix please any one replay me
Why filter transformation is an active one?
Define joiner transformation?
In which transformation you cannot drag ports into it?
What is a connected transformation?
What is parallel processing in informatica?
Explain the different kinds of facts.
What is the fact table?
What do you mean by enterprise data warehousing?
How to do the error handling of if ur source is flatfiles?
How you can differentiate between connected lookup and unconnected lookup?
