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

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,

---

in static and dynamic which one is better

2 Answers  

---

How can we use mapping variables in informatica?

0 Answers  

---

What are reusable transformations in how many ways we can create them?

2 Answers  

---

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,

---

What is confirmed dimension with scenario

1 Answers   HCL,

---

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers  

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,

---

What are the joiner caches?

3 Answers   Informatica,

---