Interested to Buy Any Domain ? << Click Here >> for more details...
My source table having some records ,i want load 1st record
and last record into one target?
- 3 Answers
- 9632 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / chandrasekar
I took the EMP table and we can use the below query in the
SQL override,
select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);
it will work.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
where to store informatica rejected data? How to extract the informatica rejected data?
What are the features of complex mapping?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain in detail about scd type 1 through mapping.
tell me about your project functionality
Scheduling properties,whats the default (sequential)
What can we do to improve the performance of informatica aggregator transformation?
What is rank transformation in informatica
what is INFORMATICA TESTING process
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the new features of informatica 9.x in developer level?
How to configure mapping in informatica?
what are 3 tech challenges/ common issues you face?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to handle decimal places while importing a flatfile into informatica?
