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

in performance wise union is past,union all is past

2 Answers  

---

What is a taget load order?

2 Answers   IBM,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

---

Could you explain what is enterprise data warehouse?

0 Answers  

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,

---

what is materialized view?

2 Answers  

---

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,

---

How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,

---