I want load the data into target with out 1st and last record.
Answers were Sorted based on User's Feedback
Answer / sree
u can override the query in SQt/r
select * from emp where rowid not in ((select min(rowid)
from emp),(select max(rowid) from emp))
Is This Answer Correct ? | 11 Yes | 1 No |
Answer / sravanthi
In source qualifier Transformation we can write the
following query.....
select rownum,x.* from (select rownum rn,e.* from emp e ) x
where rn>1 and rn<(select count(*) from emp)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / babu
Hi A.C Sekhar,
If u r source is flat file,u should take seq/tr and agg/tr
in that take first function and last function after that
take a filter/tr filter condition is seqno !=fno or seqno!
=lno.
MAPPING;
SEQ-->SEQ-->AGG-->FLT-->TRG
PORTS;
NEXTVALUE -->SNO (SEQTR-->AGG)
IN AGG/TR
1.FNO=FIRST(SNO) OUTPUT PORT.
2.LNO=LAST(SNO) OUTPUT PORT.
IF ANY THING WRONG,PLEASE LET CORRECT ME.
THANKS,
BABU.
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / santosh kumar sarangi
Hi Babu,
Can you please tell me, which port need to take as group by
port in the aggregator t/r. if you not take any group by
port then by default it is forward only last port.
Thanks & Regards
Santosh
Is This Answer Correct ? | 0 Yes | 0 No |
What is polling?
need for registering a repository server
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
How to use procedural logic inside infromatica?
What is meta data and system catalog?
what are the Methods For Creating Reusable Transformations?
server hot-ws270 is connect to Repository B. What does it mean?
What is the difference between source qualifier transformations source filter to filter transformation?
Can we call a stored procedure from a unix script which is run using command task
without using emailtask how will send a mail from informatica?
Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com