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
- 9906 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
Differentiate between Load Manager and DTM?
How to update source definition?
where to store informatica rejected data?
What is a transaction control transformation?
can you please explain me pre session and post session options?
Mention a few design and development best practices for informatica?
what is the Default Source Option For Update Strategy Transformation?
What is meant by target load plan?
What is meant by a domain?
What are the popular informatica products?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain the code page compatibility?
What is the command used to run a batch?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Can we create a node as a gateway node and the same node can be assigned to a grid?
