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

I have a flat file, want to reverse the contents of the flat file

1129

How do you handle two sessions in Informatica

1171

What are the performance considerations when working with aggregator transformation?

1155

difference between informatica 8.1.1 and 8.6

3678

What is the benefit of partitioning a session?

1183

What is a dimensional model?

986

COM components can be used in Informatica

2395

Can we create two repositories on same database instance in oracle?

1097

what is the -ve test case in your project.

2408

What is exclusive and normal mode for repository services?

1147

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2060

What is dimensional table? Explain the different dimensions.

1174

What is InformaticaPowerCenter?

1138

What is powercenter on grid?

1181

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2726