I want skip first 5 rows to load in to target? what will be
the logic at session level ??
- 1 Answers
- 7221 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 is native users?
What is a connected transformation?
what is INFORMATICA TESTING process
which is better perfomancewise lookup or joiner and why?can anyone give example?
how the informatica server sorts the strings values in rank transformations?
which one is better either active or passive transformation in informatica
On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?
Differentiate between joiner and lookup transformation?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
In informatica workflow manager, how many repositories can be created?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
Teradata 
