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
- 4843 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 |
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
What are the different types of Type2 dimension maping?
Is snow flake or star schema used? If star schema means why?
Diff b/w ShortCut and reusabel Object ?
Which will beter perform IIf or decode?
To achieve the session partition what r the necessary tasks u have to do?
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
What is the difference between SOURCE and TARGET BASED COMMITS?
Define mapping and session?
What are the methods for creating reusable transforamtions?
How might one distinguish in the case of mapping is right or not without associating session?
Teradata 
