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
- 9702 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 is exclusive and normal mode for repository services?
How to configure mapping in informatica?
What do you mean by worklet?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is powercenter on grid?
Define sessions in informatica etl?
How to create or import flat file definition in to the warehouse designer?
How to elaborate powercenter integration service?
Tell me about Propagate functions in informatica
What are the issues you have faced in your project? How did you overcome those issues?
What will be the approach?
What is workflow? What are the components of workflow manager?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
