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
- 4233 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
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is workflow monitor?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Where is metadata stored?
Partition, what happens if the specified key range is shorter and longer
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the popular informatica products?
Describe expression transformation?
Define the various join types of joiner transformation?
What are some examples of informatica etl programs?
What's the layout of parameter file (what does a parameter file contain?)?
What is an aggregator transformation?
Explain the different kinds of facts.
What you know about transaction control transformation?
