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 exclusive and normal mode for repository services?
How to start a workflow using pmcmd command?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain sessions. Explain how batches are used to combine executions?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain about cumulative Sum or moving sum?
Differences between connected and unconnected lookup?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is dynamic cache?
How to create the source and target database connections in server manager?
How union transformation is used?
What are the main issues while working with flat files as source and as targets ?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can we use batches?