Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
- 5 Answers
- 9797 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
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Why union transformation is an active transformation?
What is the function of aggregator transformation?
Write the advantages of partitioning a session?
How can we handle two sessions in informatica?
what is the Default Source Option For Update Strategy Transformation?
How to implement security measures using repository manager?
What is domain and gateway node?
What are the new features of informatica 9.x in developer level?
Explain constraint based loading in informatica
Explain what transformation and how many are there in informatica?
Clarify the utilization of aggregator cache record?
What is an expression transformation in informatica?
What are the prerequisite tasks to achieve the session partition?
How to load data in informatica ?
