how can we load starting with 11th record of a table from
source to target
- 6 Answers
- 8793 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / guest
it is not possible to take data from 11th records. because
consider this senario.. if u give select statement as
select column name1,2.... from table name where rownum<5;
this select statement wil work if u have 10 or more than 5
records in table.
now u r asking to load only from 11th record
so the query will be like this
select column name1,2,.... from table name where rownum>10;
it wil return emptyset only..
see the checking condition. it wil fetch the 1st record and
check rownum 1 > rownum 10. condition failed. so it wont go
to second record and results in empty set.
but in earlier case it wil fetch 1st record and checks
rownum 1 < rownum 5. condition satisfied. it wil load that
row and check for 2nd row and 3rd and so on until the
condition fails.
once the condition fails it wil come out.
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
How to implement security measures using repository manager?
explain abt ur project architecture?
What do you mean by channel change?
What you know about transaction control transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Can we override a native sql query within informatica?
Design time, run time. If you don't create parameter what will happen
What do you mean by blocking transformation?
Mention few power centre client applications with their basic purpose?
What is a repository? And how to add it in an informatica client?
What are the issues you have faced in your project? How did you overcome those issues?
How you know when to use a static cache and dynamic cache in lookup transformation?
How we can create indexes after completing the loan process?
r u done any partitions in ur project?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
