how to load only the first and last record of a flat file
into the target?
- 8 Answers
- 27829 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / ysr
using Aggregator trans FIRST and LAST funtions we can pass
first and last record
| Is This Answer Correct ? | 21 Yes | 9 No |
Post New Answer View All Answers
Explain transaction control transformation in informatica
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
If informatica has its scheduler why using third party scheduler?
How can you validate all mappings in the repository simultaneously?
pmscmd startworkflow -sv
Whats the difference between informatica powercenter server, repositoryserver and repository?
wat are deployement groups in informatica, how it will be used for developers
Explain lookup transformation in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a sorter transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How can a transformation be made reusable?
How an expression transformation differs from aggregator transformation?
