I want skip first 5 rows to load in to target? what will be
the logic at session level ??
- 1 Answers
- 6362 Views
- IBM, I also Faced
- E-Mail Answers
Answer / 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 |
What are the various types of transformation?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
How to generate sequence numbers?
what is lookup chache?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
Why the UNION TRANSFERMATION is an Active TRANSFERMATION
how to work with mapplet designer in informatica?
How to view and Generate Metadata Reports?
What are the informatica performance improvement tips
Design a mapping to load a target table with the following values from the above source?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Teradata 
