Interested to Buy Any Domain ? << Click Here >> for more details...
can we create index and drop index in exsisting table while
using infomatica
- 4 Answers
- 20176 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 |
Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is the diff b/w union and joiner and lookup?
What is the commit type if you have a transaction control transformation in the mapping?
How we can create indexes after completing the loan process?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
What are the differences between source qualifier and joiner transformation?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
Roles and Responsibilties of Informatica Production Support Member?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
Teradata 
