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

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

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  


source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,


How to jion 2 tables, without using any condition?

11 Answers   Amazon,






can u any challenge your project?

0 Answers   HP,


without dynamic lookup transformation how to insert new rows and update existing rows?

7 Answers   Cap Gemini,


Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  


on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,


How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  


how to through logic of informatica using the push down optimization into oracle.

2 Answers   Hexaware,


Why sorter is an active transformation?

0 Answers   Informatica,


Categories