1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / guest

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

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

can every transfomation reusable?how?

2 Answers   Wipro,

Could any one to tell Fact table Partitioning?

2 Answers  

if we have a delimiters at unwanted places in a flat file how can we over come those.

1 Answers  

What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,

How the Informatica Server reads perameter file?

1 Answers  

What are Rapid changing dimensions?

1 Answers  

expain about the tune parameters?

1 Answers   TCS,

disable caching in a lookup transformation?

1 Answers  

How many ways are there to create ports?

1 Answers   Informatica,

How can repository reports be accessed without sql or other transformations?

1 Answers  

what is flat file override?

1 Answers   Cap Gemini, HP,

For more Informatica Interview Questions Click Here
Categories