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.

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

---

waht is dataware house

2 Answers  

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---

Different sorts of metadata that stores in the storage facility?

0 Answers  

---

what is the flat file partition and where have to specify it

1 Answers   TCS,

---

What is up date strategy and what are the options for update strategy?

2 Answers  

---

Which kind of index is preferred in DWH?

2 Answers  

---

What do you mean by filter transformation?

0 Answers  

---

What is IQD file?

1 Answers  

---

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

How can u stop a batch?

2 Answers  

---