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
- 6804 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 many ways are there to create ports?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How the informatica server increases the session performance through partitioning the source?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
All active transformations r passive or not?
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
Where do we use mapping variables in informatica?
how can we perform incremental aggregation?explain with example?
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
what are the difference between Informatica 7.1 and 8.1?
What are the options in the target session of update strategy transsformatioin?
Teradata 
