Answer / subhrangshu

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.

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

---

What is confirmed dimension with scenario

1 Answers   HCL,

---

How will u find weather dimension table is big in size of a fact table?

1 Answers  

---

Two Default User groups created in the repository are ____ and ______

2 Answers  

---

Why touse stored procedure in ETL Application?

2 Answers  

---

My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,

---

what is casual dimension?

6 Answers   IBM,

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  

---