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
- 9813 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
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 are the different types of transformation available in informatica. And what are the mostly used ones among them?
EXL informatica Questions
What is a joiner transformation?
What is the sql query overwrite in source qualifier in informatica
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Which files are created during the session rums by informatics server?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What do you mean by filter transformation?
What is the different lookup cache(s)?
Design time, run time. If you don't create parameter what will happen
What is a surrogate key?
What if the source is a flat-file?
Explain sessions?
