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
- 4769 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 a repository? And how to add it in an informatica client?
HOW TO GET THE LATEST DATA IN SCD ?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?
Hello all, In SOA architecture i.e 8.6 , What is mean by node exactly?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
What is lookup change?
Differences between connected and unconnected lookup?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
What is the sequence generator transformation in informatica?
How to handle decimal places while importing a flatfile into informatica?
Teradata 
