Interested to Buy Any Domain ? << Click Here >> for more details...
I want skip first 5 rows to load in to target? what will be
the logic at session level ??
- 1 Answers
- 7085 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nitin
The one way to skip records for relational sources would be
adding a SQL Query in session properties.
SELECT * FROM EMPLOYEE
MINUS
SELECT * FROM EMPLOYEE WHERE ROWNUM <= 5
This query would skip the first 5 records.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What does role playing dimension mean?
What is InformaticaPowerCenter?
What is a sequence generator transformation?
What is Index Caches size?
What are the data movement modes in informatica?
What are roles and groups and benefits of using them?
What are session parameters ? How do you set them?
How to improve the performance of a session using sorter transformation?
What is depict expression change?
What is the function of look up transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Design a mapping to load a target table with the following values from the above source?
What are the static cache and dynamic cache in informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
where to store informatica rejected data?
