i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
Answer Posted / chandrasekar
Please try the SQL query in the SQL override,
select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);
if it wrong means please mail to me chandranmca2007@gmail.com
Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How to differentiate between the active and passive transformations?
Define enterprise data warehousing?
How does a rank transform differ from aggregator transform functions max and min?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain sessions and how many types of sessions are there?
what are factless facts? And in which scenario will you use such kinds of fact tables.
pmscmd startworkflow -sv
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is sq transformation?
What are the components of Informatica? And what is the purpose of each?
how tokens will generate?
In which transformation you cannot drag ports into it?
Differentiate between reusable transformation and mapplet.
How to do unit testing in informatica?
What are the different transaction levels available in transaction control transformation?