Interested to Buy Any Domain ? << Click Here >> for more details...
how to load only the first and last record of a flat file
into the target?
- 8 Answers
- 30653 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
first record can be loaded using the top and only one rank
in ranker transformation.
the last record using aggregator without group by option.
| Is This Answer Correct ? | 14 Yes | 2 No |
Answer / ysr
using Aggregator trans FIRST and LAST funtions we can pass
first and last record
| Is This Answer Correct ? | 21 Yes | 9 No |
Answer / ghouse
we can write the shell script for it
head -1
tail -1
we call it either in command task or pre and post session
shell commands in seession
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / etl guru
not possible first & last function in aggregator
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / ram pothineni
Create a port in Expression t/r and generate a value for
each row using SEQ genrator, then in Agr take count of all
the records. Create 2 condition in router one with SEQ = 1
and another with SEQ = count of rows (this will give last
row). Connect both to target. Dont forget to give reset
option in SEQ generator.
http://it.toolbox.com/people/raambabuchowdary/
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / sanjay gupta
Hi ysr
Can u define the steps please or can u send mapping on my
email id i.e. sanjayguptaa04@gmail.com?
I tried but i am unable to do it..
Thanx in advance
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / tilak
use sequence generator , pass values only with max and min
sequence number filter to target
| Is This Answer Correct ? | 4 Yes | 8 No |
what is lookupoverriding?
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
Define Incremental Aggregation?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
What are the differences between a connected lookup and unconnected lookup?
What is IQD file?
what is constraint based loading
Explain about HLD and LLD ?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
After we make a folder shared can it be reversed?Why?
Can anyone tell me the new features in Informatica 9 Version?
What are the restrictions of union transformation?
Teradata 
