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
- 4750 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
How do you load only null records into target?
How do you load alternate records into different tables through mapping flow?
what is the complex transformation you used in informatica
What is meant by LDAP users?
What is deployment group?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is rank transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
What are Dimensional table?
What are the differences between source qualifier and joiner transformation?
What are mapplets?
How can repository reports be accessed without sql or other transformations?
Explain what are the different types of transformation available in informatica.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
