Interested to Buy Any Domain ? << Click Here >> for more details...
How to eliminate 1st and last rows from the source and load
the inbetween rows.
- 5 Answers
- 26175 Views
- Syntel, I also Faced
- E-Mail Answers
Answer Posted / sagarreddy
in source qualifier your using this query like this u get it
easily
select rowid from tablename
minus
(select min(rowid) from tablename
union
select max(rowid) from tablename )
if u write this query will work it plz go through it
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What do you understand by SOA of Informatica?
Can we change Dynamic to Static or Persistent cache? If so what happens?
tell me about your project functionality
Informatica settings are available in which file?
Differences between version 7.x and 8.x.
How can a transformation be made reusable?
What is the need of an ETL tool?
Can we override a native sql query within informatica?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
On which transformations you created partitions in your project?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Can we create two repositories on same database instance in oracle?
What do think which one is the better joiner or look up?
What is meant by lookup transformation?
