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
- 4070 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 |
Why do we need informatica?
what are testing in a mapping level please give brif eplanation
where does the default group roew in a router is stored what is the default size of memory in router
What the difference is between a database, a data warehouse and a data mart?
differences between service based and product based?
what is data driven in informatica
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
Can we make worklet inside worklet?
What do you mean incremental aggregation?
Which transformation is needed while using the Cobol sources as source definitions?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Teradata 
