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
- 12203 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
Describe expression transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Quickly characterize reusable change?
What is a repository manager?
Can we override a native sql query within informatica?
explan ur project architecture?
How can we use mapping variables in informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is repository manager?
How does a rank transform differ from aggregator transform functions max and min?
Repository user profiles
What are the data movement modes in informatica?
Mention a few design and development best practices for informatica?
How is union transformation utilized?
Define filter transformation?
