Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

0 Answers  

---

What is the different lookup cache(s)?

0 Answers  

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

What is a transaction control transformation?

0 Answers   Informatica,

---

Can we create two repositories on same database instance in oracle?

0 Answers  

---

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers   CTS,

---

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

---

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

---

How to generate sequence numbers?

0 Answers  

---

How to load time dimension?

1 Answers   Ford,

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---