Interested to Buy Any Domain ? << Click Here >> for more details...
How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
- 1 Answers
- 4673 Views
- I also Faced
- E-Mail Answers
Answer Posted / subhrangshu
Sequence generator may create issue in case of partitioning. The duplicate keys get generated in sequence generator. We cannot have cannot have multiple table feeder processes.
Then, we can use either Oracle database sequences or Lookup / Expression transformation to create sequence numbers. Although, Oracle sequences are better as it
will also handle the case where there are other sources feeding the Target under consideration other than ETL. Yes, there is slight hit in performance, but it's minor in most situations.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain how to import oracle sequence into informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain lookup transformation in informatica
What are active and passive transformations?
How are indexes created after completing the load process?
explan ur project architecture?
What is the Process to creating lookup transformation in informatica
Can u generate reports in Informatica?
While migrating the data from one environment to another environment how would you manage the connections?
How to extract sap data using informatica? What is abap? What are idocs?
How you can differentiate between connected lookup and unconnected lookup?
Repository user profiles
What is a joiner transformation and why it is an active one?
generate date / time dimension in informatica
Explain about cumulative Sum or moving sum?
