Source (Flatfile) - Target (1-1 mapping). How to load first or
last 20 record to target?
- 5 Answers
- 9833 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 the benefit of session partitioning?
Explain the etl program with few examples.
What is the use of an aggregator cache file?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Define mapplet?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is main use of mapplet?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
How to convert multiple rows to single row (multiple columns) in informatica
What is a joiner transformation and why it is an active one?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Briefly define a session task?
Enlist some properties of sessions.
Sequence generator, when you move from develoment to production how will you reset
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
