can we create index and drop index in exsisting table while
using infomatica
- 4 Answers
- 18415 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 |
What are the circumstances that infromatica server results an unreciverable session?
how to load only the first and last record of a flat file into the target?
What are the reusable transformations?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
whatis the default data driven operation in informatica
explain about lookup t/r?
Explain the scenario which compels informatica server to reject files?
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
What is up date strategy and what are the options for update strategy?
Two Default User groups created in the repository are ____ and ______
Teradata 
