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
- 19989 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 |
How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
Can you copy the batches?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
What is intricate mapping?
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
Why do you use Mapping Parameter and mapping variable?
How to delete first 3 rows & last 3 rows in target table in informatica
How to generate sequence numbers?
What is lookup transformation?
Teradata 
