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
- 6969 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 worklet?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is a filter transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
what is mean by complex business rule ?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What are the types of lookup transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How would you copy the content of one repository to another repository?
What is a transaction control transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Clarify the aggregator change?
how tokens will generate?
what are the deliverables?in your project?
