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
- 9061 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
Explain Dataware house architecture .how data flow from intial to end?
How does a sorter cache works?
What is parallel processing in informatica?
Can we create multiple integration service on single repository?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Define enterprise data warehousing?
Explain the types of transformations?
How to update or delete the rows in a target, which do not have key fields?
How identifying bottlenecks in various components of informatica and resolving them?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Separate from an archive server and a powerhouse?
Explain scd type 3 through mapping.
Explain sessions and how many types of sessions are there?
Define sessions in informatica etl?
What is data movement mode in Informatica and difference between them?
