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
- 4433 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 |
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
Implementation methodology
Design time, run time. If you don't create parameter what will happen
What are the advantages of using informatica as an etl tool over teradata?
what is the difference between onsite & client site?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
In joiner, how to load Master table in Target?
my source is junk data how will u remove that junk data by using unix please any one replay me
Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?
what is the look up transformation?
What is a joiner transformation?
Can you access a repository created in previous version of Informatica?
Teradata 
