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
- 25930 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 are the designer tools for creating transformations?
Design time, run time. If you don't create parameter what will happen
What is workflow monitor?
What is the difference between STOP and ABORT options in Workflow Monitor?
How can a transformation be made reusable?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How can repository reports be accessed without sql or other transformations?
What is dimensional table?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is meant by pre and post session shell command?
What is a sequence generator transformation?
In which transformation you cannot drag ports into it?
Describe the impact of several join conditions and join order in a joiner transformation?
How can one identify whether mapping is correct or not without connecting session?
Explain constraint based loading in informatica
