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
- 11340 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 complex mapping?
Explain load alternative records / rows into multiple targets - informatica
Define update strategy?
What is primary and backup node?
How to partition the Session?
How we can use union transformation?
What are mapplets?
What is the benefit of partitioning a session?
What are the types of lookup transformation?
wat are deployement groups in informatica, how it will be used for developers
How to call shell scripts from informatica?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What happens when a session fails and you click on recover?
