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
- 4680 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 to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
What is a design?
Two different admin users created for repository are ______ and_______
How to list Top 10 salary, without using Rank Transmission?
Explain lookup transformation in informatica
What is a filter transformation?
what is the exact meaning of domain?
How to import oracle sequence into Informatica?
what are objects in data warehouse?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
What is predefined event?
can we use self join in informaitca?
Teradata 
