How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?



How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator trans..

Answer / 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

More Informatica Interview Questions

Please let me know how to make Data masking in informatica..

0 Answers  


how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,


What is a command that used to run a batch?

2 Answers  


How we can create indexes after completing the load process?

0 Answers  


Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,


list out all the transformations which use cache?

0 Answers   Informatica,


Where can we find the throughput option in informatica?

0 Answers  


Where do you create/define mapping parameter and mapping variable?

1 Answers  


Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,


performance wise which one is better in joiner and lookup transformation

2 Answers  


When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?

1 Answers  


What is facttable granularity?

2 Answers  


Categories