can we create index and drop index in exsisting table while
using infomatica
- 4 Answers
- 19126 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / roshan
one more way is to write stored procedure and use target pre load and target post load option using unconnected stored procedure T/R...
for more detail
infernonag@gmail.com
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / amarnath
when you import a target into designer you have an option
to drop constraints or create it and some other options as
well. go and edit the target u will fins all the options.
u can drop constraints and index before loading and re-
create it after the load with these options. this is the
simple method provided by informatica.
| Is This Answer Correct ? | 1 Yes | 2 No |
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
Where are the source flat files kept before running the session?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
What are the different options available for update strategy?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
what is the use of Data Mart?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
Suppose we do not group by on any ports of the aggregator what will be the output?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the different components of powercenter?
How might you approve all mappings in the archive all the while?
Teradata 
