Interested to Buy Any Domain ? << Click Here >> for more details...
I want load the data into target with out 1st and last record.
- 5 Answers
- 9934 Views
- Yash Technologies, I also Faced
- E-Mail Answers
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 are the types of caches in lookup?
How to elaborate powercenter integration service?
write a query to retrieve the latest records from the table sorted by version(scd)
What is resilience time?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
Is it possible to revert a global repository to local one and why?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is an unconnected transformation?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
Which gives the more performance when compare to fixed width and delimited file ? and why?
disable caching in a lookup transformation?
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
Teradata 
