If you want to create indexes after the load process which
transformation you choose?
- 3 Answers
- 19538 Views
- HCL, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
stored procedure transformation can be used to create and
drop indexes before and after loading into the target.
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / kalyan
use the post session SQL to craete indexes on the target
table..
| Is This Answer Correct ? | 11 Yes | 1 No |
How will the document be delivered to me?
How you can differentiate between connected lookup and unconnected lookup?
How can i send first half of the records to one target and Remaining to other target?
what is the size of ur database(like oracle)
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
what is the use of Data Mart?
Explain direct and indirect flat file loading (source file type) - informatica
What is meant by active and passive transformation?
What are the parts of Informatica Server?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
connected and unconnected lookups?
Teradata 
