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
- 20033 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 |
State the differences between sql override and lookup override?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
How to update a particular record in target with out running whole workflow?
What are the designer tools for creating tranformations?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
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
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
What are the steps involved in the migration from older version to newer version of Informatica Server?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the different types of repositories created using informatica?
Can we create two repositories on same database instance in oracle?
Teradata 
