If you want to create indexes after the load process which transformation you

If you want to create indexes after the load process which
transformation you choose?

Question Posted / guest

3 Answers
21484 Views
HCL, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If you want to create indexes after the load process which transformation you choose?..

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

If you want to create indexes after the load process which transformation you choose?..

Answer / kalyan

use the post session SQL to craete indexes on the target
table..

Is This Answer Correct ?

11 Yes

1 No

If you want to create indexes after the load process which transformation you choose?..

Answer / prasad

unconnected stored procedure with the property called target
post load

Is This Answer Correct ?

2 Yes

0 No

Post New Answer

More Informatica Interview Questions

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.

1 Answers Cipla, Quintiles,

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers Wipro,

How big was your fact table

0 Answers

list out all the transformations which use cache?

0 Answers Informatica,

Explain the types of lookup transformation?

0 Answers

How to delete the (flat file) data in the target table after loaded.

2 Answers TCS,

What is the difference between IN and Exists in Oracle?

4 Answers Deloitte,

How can u insert o ne row in the target if that row does not exists in the target and update if it exists