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 is a surrogate key?
What is the way to execute pl/sql script using informatica mapping?
What are the different ways to implement parallel processing in informatica?
What is the procedure for creating independent data marts from informatica 7.1?
What is Index Caches size?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Please let me know how to make Data masking in informatica..
What is powercenter on grid?
On which transformations you created partitions in your project?
What do you mean by worklet?
Separate from an archive server and a powerhouse?
Parameter and variable differences
Explain scd type 3 through mapping.
What is dimensional table?
Differentiate between source qualifier and filter transformation?