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
- 7066 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 |
generate date / time dimension in informatica
how can u avoid duplicate rows in flat file?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
how to design mapping half of source table records into one target and remaining half into another target
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is a joiner transformation and why it is an active one?
Explain what transformation and how many are there in informatica?
How do you load first and last records into target table?
What is xml source qualifier transformation in informatica?
why we need informatica
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
Teradata 
