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
- 9924 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
Define mapping and session?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain the features of connected and unconnected lookup.
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How to join three sources using joiner? Explain though mapping flow.
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.
without table how to come first record only in oracle?
What are the popular informatica products?
Explain the difference between a data warehouse and a data mart?
Different sorts of metadata that stores in the storage facility?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are the different options available for update strategy?
Explain the pipeline partition with real time example?
Which transformation should we use to normalise the COBOL and relational sources?
what is the difference between informatica6.1 and infomatica7.1
