How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?
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 |
Please let me know how to make Data masking in informatica..
how can u avoid duplicate rows in flat file?
What is a command that used to run a batch?
How we can create indexes after completing the load process?
Performance wise which is better joiner or look up ? Give me with example?
list out all the transformations which use cache?
Where can we find the throughput option in informatica?
Where do you create/define mapping parameter and mapping variable?
Performance tuning in UNIX for informatica mappings?
performance wise which one is better in joiner and lookup transformation
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?
What is facttable granularity?