Interested to Buy Any Domain ? << Click Here >> for more details...
I want load the data into target with out 1st and last record.
- 5 Answers
- 9768 Views
- Yash Technologies, I also Faced
- E-Mail Answers
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
How to Create a folder using pmrep command?
To import the flat file definition into the designer where should the flat file be placed?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is the use of transformation?
Explain sessions?
Enlist some properties of sessions.
How union transformation is used?
What are the components of the workflow manager?
What is the need of an ETL tool?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
State the differences between sql override and lookup override?
What are the prerequisite tasks to achieve the session partition?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is depict expression change?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
