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
- 7162 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 is a node in Informatica?
Explain scd type 3 through mapping.
What are the components of Informatica? And what is the purpose of each?
What is dimensional table? Explain the different dimensions.
Can we create a Integration service without a Repository service and vice versa?
How to partition the Session?
What are batches?
Separate from an archive server and a powerhouse?
What are the types of lookup transformation?
Explain the scenario which compels informatica server to reject files?
What the difference is between a database, a data warehouse and a data mart?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the tuning techniques you applied during your last project
How do you convert single row from source into three rows into target?
