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?
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 |
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
Without using Lookup & Sequence Generator, How to generate Sequence?
How many input parameters can exist in an unconnected lookup?
Explain constraint based loading in informatica
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
How to create Target definition for flat files?
What is the Hierarchy of DWH?
Explain the types of lookup transformation?
What is Micro Strategy? Why is it used for?