Work flow failed when it is set to Bulk mode but it was
successful
when set to normal mode y??(All the connections are fine and
exactly
correct)?

Answer Posted / satya

Hi floks,

There some limitations to the BULK mode. U cant use BULK
mode in the below cases.

1. target table is not relational
2. if the target is relational but a primary key is declared
or Index is created on any of the columns.
3. If the mapping contains Update strategy.

So as per myunderstanding issue could be any one of the
above reasons. Pls check.

Satya

Is This Answer Correct ?    17 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

As union transformation gives UNION ALL output, how you will get the UNION output?

639


What is the function of union transformation?

612


What are the static cache and dynamic cache in informatica?

707


What is substr in informatica?

659


What do you mean by enterprise data warehousing?

634






What is the meaning of decode in informatica?

643


What are the different components of powercenter?

578


How can you validate all mappings in the repository simultaneously?

751


Write the program through which the records can be updated?

507


Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1497


What are junk dimensions?

626


How to update a particular record in target with out running whole workflow?

1149


Which files are created during the session rums by informatics server?

700


How can repository reports be accessed without sql or other transformations?

717


Under which circumstances, informatica server creates reject files?

589