Answer / parikhita prusty

Bulk load never support the index.so if index in target with
bulk load the session will fail.so before use bulk load u
have to drop index in target,Normal load supports index.

Answer / surya

Bulk load never support the index.so if index in target with
bulk load the session will fail.so before use bulk load u
have to drop index in target and recreate index using
target post sql

Answer / babu

Hi Frnds,

Bulk load support if the target has index.but u have to
disable the ENABLE PARALL MODE OPTION in the connection
object tab.

Navigation:
WrkflowManager==>connections(Tab)==>Relationalconnection==>
Objects==>object name==>Edit==>Attributes==>Enable Parallel
Mode(check box)

By default it was enabled.

Thanks &Regards
Babu
8861145051

Answer / parikhita prusty

BULK LOAD DOESN'T SUPPORT THE INDEX.BULK LOAD BY PASSES LOG WHICH WE CAN'T RECOVER THE SESSION WHEN SESSION FAILS.MOSTLY WE USE INDEX FOR SELECT STATEMENT WHICH INCREASES THE PERFORMANCE WHEN WE INSERT THE RECORDIN A TABLE HAVIN INDEX IT DECREASES THE PERFORMANCE.SO BEFORE INSERT THE DATA IN THE TABLE WE HAVE TO DROP OR DISABLE THE INDEX WHICH INCREASES THE PERFORMANCE.NORMAL LOAD SUPPORT THE INDEX.

REGARD'S
PARIKHITA

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

0 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,

---

Explain the features of connected and unconnected lookup.

0 Answers  

---

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---

---

Can you generate reports in Informatcia?

1 Answers  

---

How informatica process data means how informatica works?

2 Answers   TCS,

---

what is parameter file?

1 Answers   Cap Gemini,

---

Explain the flow of data in Iinformatica?

1 Answers  

---

without table how to come first record only in oracle?

0 Answers  

---

Write the unconnected lookup syntax and how to return more than one column.

0 Answers  

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---