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
- 5785 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 |
Can we update the data in flat file using update strategy?
What is confirmed dimension and fact?
How to load dimension and fact in same mapping at same time.explain me the logic used for that scenario.
What is the Difference between sorter and aggregator?
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are active transformations? Name them.
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks
How you can differentiate between connected lookup and unconnected lookup?
What is degenerated dimention table?
get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c
Teradata 
