Interested to Buy Any Domain ? << Click Here >> for more details...
If a table contains 100 records we have to fetch 50-100
records from source to target?how
- 7 Answers
- 12754 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / udit
If the question is like they want to load next half record then we write query in source qualifier
select * from table
minus
Select * from table
where rownum<=(select count(*)/2 from table)
this query will load the next half i.e. from 50 to 100 records
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are data-driven sessions?
How to load last n records of file into target table - informatica
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.
How to delete duplicate row using informatica?
generate date / time dimension in informatica
What is blocking transformation?
Different sorts of metadata that stores in the storage facility?
How do you promote a non-reusable transformation to reusable transformation?
What if the source is a flat-file?
How does a rank transform differ from aggregator transform functions max and min?
What is Cognos script editor?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
How to do the error handling of if ur source is flatfiles?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What are the types of lookup transformation?
