Interested to Buy Any Domain ? << Click Here >> for more details...
One flatefile it contains some data but i want to dont want
to load first and last record ..how it is? can u tell me
complete logic?
- 2 Answers
- 6718 Views
- I also Faced
- E-Mail Answers
Answer Posted / purushothaman
put one expression after the source qualifer
and type this code
for example take this record
HDR20008
....
TRL2000800020
output variable name = IFF(SUBSTR(columnname ,1,3)
='HDR','Y','N')
Similarly put for trailer record condition in the
expression
after this expression put the one filter like this
output variable name ='Y'
cheers!!!!!!!!!!!!!!!!!
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
How to generate sequence numbers using expression transformation?
What are the new features of Power Center 5.0?
What is intricate mapping?
Explain the use of aggregator cache file?
What are the restrictions of union transformation?
How do you load only null records into target?
What is the difference between stop and abort in informatica
What are the different clients of powercenter?
In how many ways we can create ports?
What is workflow monitor?
What is the Process to creating lookup transformation in informatica
Mention few power centre client applications with their basic purpose?
How to extract sap data using informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Informatica Checkpoints
