Interested to Buy Any Domain ? << Click Here >> for more details...
i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
- 6 Answers
- 9955 Views
- Emphasis, I also Faced
- E-Mail Answers
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 3 tech challenges/ common issues you face?
Why do we need informatica?
How do you handle two sessions in Informatica
How to do unit testing in informatica? How to load data in informatica ?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Difference between Target-based loading and constraint-based loading?
What are active and passive transformations?
How are indexes created after completing the load process?
In informatics server which files are created during the session rums?
How do you remove duplicate records in informatica? And how many ways are there to do it?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the session task and command task?
can anyone explain me about retail domain project in informatica?
what is index?how it can work in informatica
What is confirmed fact in dataware housing?
