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
- 9794 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
How identifying bottlenecks in various components of informatica and resolving them?
what is size of u r database?
How can we remove the duplicates from flat file source?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How many types of sessions are there in informatica.please explain them?
How many numbers of sessions can one group in batches?
What is repository manager?
Reusable transformation and shortcut differences
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the use of code page?
how we can load rejected record's at run time?(not through bad files)
pmscmd startworkflow -sv
Explain the aggregator transformation?
differences between service based and product based?
