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
- 8434 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 EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
can we override a native sql query within informatica? Where do we do it? How do we do it?
Why filter transformation is an active one?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Target increases every day even though no new record was inserted
What is the meaning of decode in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the differences between source qualifier and joiner transformation?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How many input parameters can exist in an unconnected lookup?
What is informatica?
What is event and what are the tasks related to it?
Can we create multiple integration service on single repository?
Briefly define a session task?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
