Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
- 5 Answers
- 10112 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 are the static cache and dynamic cache in informatica?
How to go to the older version for a mapping?
What are junk dimensions?
Can u generate reports in Informatica?
What is a snowflake schema?
How to generate sequence numbers using expression transformation?
What is a transaction control transformation?
What is decode in informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Can we create two repositories on same database instance in oracle?
How do you set a varible in incremental aggregation
While migrating the data from one environment to another environment how would you manage the connections?
What is the difference between informatica 7.0 and 8.0?
What is a filter transformation?
Target increases every day even though no new record was inserted
