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
- 11516 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
What is xml source qualifier transformation in informatica?
How we can create indexes after completing the load process?
Where are the source flat files kept before running the session?
How can you differentiate between powercenter and power map?
have u done any performance tuning? how u ll do?
How can you define user defied event?
How to do the error handling of if ur source is flatfiles?
What is a snowflake schema?
What is the maplet?
What is the surrogate key?
Why union transformation is an active transformation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
tell me 5 session failure in real time how can you solve that in your project?
Can we get 1st record through Informatica(without sequence number).
What is the status code in stored procedure transformation?
