u can override the query in SQt/r select * from emp where rowid not in ((s

I want load the data into target with out 1st and last record.

Question Posted / sree

Answer Posted / sree

u can override the query in SQt/r
select * from emp where rowid not in ((select min(rowid)
from emp),(select max(rowid) from emp))

Is This Answer Correct ?

11 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is enterprise data warehousing?

988

What is a pre-defined event and user-defined event?

976

Write the program through which the records can be updated?

938

What is the difference between router and filter?

1155

How many transformations can be used in mapplets.

1874

Explain scd type 3 through mapping.

918

Why do we need informatica?

928

Design a mapping to load the cumulative sum of salaries of employees into target table?

1424

How do you use reject loader.

2547

what is the hint? how to use it to reduce the query processing in program?

7634

Is it possible to revert a global repository to local one and why?

1026

What is informatica powercenter repository?

1144

Explain in detail about scd type 1 through mapping.

1300

How can we create index after completion of load process?

1073

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2239