If I have a index defined on target table and if set it to
bulk load will it work ?

Answers were Sorted based on User's Feedback



If I have a index defined on target table and if set it to bulk load will it work ?..

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.

Is This Answer Correct ?    21 Yes 0 No

If I have a index defined on target table and if set it to bulk load will it work ?..

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

Is This Answer Correct ?    5 Yes 0 No

If I have a index defined on target table and if set it to bulk load will it work ?..

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

Is This Answer Correct ?    3 Yes 0 No

If I have a index defined on target table and if set it to bulk load will it work ?..

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,


What is the advantage of informatica?

0 Answers  


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

0 Answers   CTS,


What is limitations of truncate and load option

1 Answers   Cap Gemini,


How to load a Dimension ? and how to load a fact table?

0 Answers  


How many repositories can be created in informatica?

1 Answers  


what is diffrence b/w joner and union transfermation

6 Answers  


what is filelist concept in informatica

4 Answers  


1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

0 Answers   CTS,


Which is better performance wise database or file?How?

2 Answers   TCS,


what are the limitation of sorter transformation?

2 Answers   TCS,


what is row level and column level indicator?

1 Answers   TCS,


Categories