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
- 7062 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
Explain the informatica workflow?
Clarify the utilization of aggregator cache record?
How do you change a non-reusable transformation to reusable transformation?
What is primary and backup node?
How can informatica be used for an organization?
What is the maplet?
Define Pmrep command?
What is meant by a domain?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Where do we use mapping variables in informatica?
How many ways a relational source definition can be updated and what are they?
Write the program through which the records can be updated?
What are the new features of informatica 9.x in developer level?
Describe the impact of several join conditions and join order in a joiner transformation?
