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


Please Help Members By Posting Answers For Below Questions

What are the main features of Oracle 8i with context to datawarehouse?

1881


What are the different lookup cache(s)?

845


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

1746


Explain the aggregator transformation?

864


What is lookup transformation?

833


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.

1483


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2212


What is a rank transform?

869


what is song in infrmatica...?

1937


Can we create two repositories on same database instance in oracle?

860


draw informatica architecture 8.6 ?

3656


What are the different options available for update strategy?

782


is it possible to index the data in cache of lkp transformation ?

1749


What are the types of schemas we have in data warehouse and what are the difference between them?

741


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

1771