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
- 19827 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 |
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
What is galaxy shema
Enlist the tasks for which source qualifier transformation is used.
Reusable transformation and shortcut differences
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
What is event and what are the tasks related to it?
Performance wise which is better joiner or look up ? Give me with example?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
In target table how to display the system time
What is difference between Mapplet and reusable transformation?
what is the -ve test case in your project.
Teradata 
