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
What are the main features of Oracle 8i with context to datawarehouse?
What are the different lookup cache(s)?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Explain the aggregator transformation?
What is lookup transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is a rank transform?
what is song in infrmatica...?
Can we create two repositories on same database instance in oracle?
draw informatica architecture 8.6 ?
What are the different options available for update strategy?
is it possible to index the data in cache of lkp transformation ?
What are the types of schemas we have in data warehouse and what are the difference between them?
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