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
- 6587 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashok nidamanuri
We can implement like this
1)Take sequence genarator transformation and get sequence
of no's for each and every record
2)Then in expression take two output port's like out_min
and out_max.Assign Min and Max functions to corrsponding
output ports then u will get Min and max value of the
records
3)Take filter transformaton and filter those two records in
filter tarnsformation.
try with this!!!!!!!!!!!!!!!!!!!
| Is This Answer Correct ? | 3 Yes | 6 No |
Answer / 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 |
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
What is a taget load order?
What does refresh system mean, and what are its distinctive choice?
how to get flatfile containg 10 records half records one target another half another target
Which gives the more performance when compare to fixed width and delimited file ? and why?
EXL informatica Questions
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
create a mapping to retrieve the employees who are getting salary greater than average salary?
What is the filename which you need to configure in UNIX while installing infromatica?
I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How the informatica server increases the session performance through partitioning the source?
Teradata 
