If I have a index defined on target table and if set it to
bulk load will it work ?
- 4 Answers
- 14019 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
have u done any performance tuning? how u ll do?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the function of aggregator transformation?
How to elaborate powercenter integration service?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the types of lookup transformation?
How to use pmcmd utility command?
What is the function of look up transformation?
What is the benefit of partitioning a session?
Briefly define reusable transformation?
What is target load order?
