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
- 6989 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 do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is data transformation manager process?
What is the use of target designer?
Briefly explain the aggregator transformation?
How to load last n records of file into target table - informatica
What are ETL Tools?
What are mapplets? How is it different from a Reusable Transformation?
Is there any target staging area in informatica not staging area
What does update strategy mean, and what are the different option of it?
How do you set a varible in incremental aggregation
What are the data movement modes in informatica?
What is a repository? And how to add it in an informatica client?
What are the mapping parameters and mapping variables?
Define filter transformation?
What are the measure objects?
