I want load the data into target with out 1st and last record.
Answer Posted / sravanthi
In source qualifier Transformation we can write the
following query.....
select rownum,x.* from (select rownum rn,e.* from emp e ) x
where rn>1 and rn<(select count(*) from emp)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x in developer level?
generate date / time dimension in informatica
How can repository reports be accessed without sql or other transformations?
What is pmcmd command?
What is Data Caches size?
What is target designer and target load order?
What is workflow manager?
What do you mean incremental aggregation?
Define update strategy?
Difference between Data and Index Caches?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is rank transform?
What is a repository manager?
Enterprise data warehouse your projects phase by phase explain?
What is a surrogate key?