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
- 6799 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
What is InformaticaPowerCenter?
What is the status code in stored procedure transformation?
Can anyone tell me the new features in Informatica 9 Version?
Explain the shared cache and re-cache?
Explain joiner transformation in informatica
While migrating the data from one environment to another environment how would you manage the connections?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How do you promote a non-reusable transformation to reusable transformation?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Explain the scenario which compels informatica server to reject files?
What are the reusable transformations?
update strategy transformation in informatica
Can u generate reports in Informatica?
How can we create index after completion of load process?
Write the unconnected lookup syntax and how to return more than one column.
