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
- 4399 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
What is dimensional table?
What is the scenario which compels informatica server to reject files?
What happens when a session fails and you click on recover?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
generate date / time dimension in informatica
What are the different components of powercenter?
How to create the source and target database connections in server manager?
What is a sequence generator transformation?
wf dont have integration severances how you can run?
What is the difference between Active and Passive transformation?
How to load last n records of file into target table - informatica
How many input parameters can exist in an unconnected lookup?
Which transformation should we use to normalise the COBOL and relational sources?
What is sq transformation?
How will the document be delivered to me?
