Answer / sujana

v need to disable constraints while performing bulk loading

Answer / sunil

Bulk load is used for external loaders and in bulk load we
will not write information to datalog file so if any
recovery is needed it is not possible

Answer / vikas

1.update strategy
2.no constraints on target
3.target should be relational database
4.less number of records

Explain what are the different types of transformation available in informatica.

0 Answers  

---

Explain scd type 3 through mapping.

0 Answers  

---

tell me about your project functionality

0 Answers  

---

How we can confirm all mappings in the repository simultaneously?

1 Answers  

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

---

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

---

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

---

How many number of sessions that u can create in a batch?

3 Answers  

---

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

---

How to recover sessions in concurrent batches?

3 Answers  

---