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
- 6727 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 |
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
From where we can start or use pmcmd?
Can we get 1st record through Informatica(without sequence number).
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
How to recover sessions in concurrent batches?
in which situations do u go for snowflake schema ?
Which is costliest transformation? costly means occupying more memory?
What is a data modeling?
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
How can u work with remote database in informatica?did you work directly by using remote connections?
How can you define a transformation? What are different types of transformations in Informatica?
Teradata 
