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
- 4780 Views
- I also Faced
- E-Mail Answers
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 |
what is the look up transformation?
what happens when a batch fails?
What are the different clients of powercenter?
Normalizer transformation is not involved in Mapplet.. why???
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
What is option by which we can run all the sessions in a batch simultaneously?
How to eliminate duplicates in FF and oracle both
How we will implement Pushdown Optimization and Types in Informatica with better examples
What is the fact table?
why we r using presql&postsql in source qualifier?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
Teradata 
