Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How will you update the row without using update statergy?

10 Answers   CTS,

How can you increase the performance in joiner transformation?

0 Answers  

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

what is lookup chache?

1 Answers   Patni,

what is work of PUSH DOWN option

2 Answers   Wipro,

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,

How the dimensions will be loaded?

0 Answers   HCL,

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

Name the different lookup cache(s)?

0 Answers  

What are the phases in SDLC?

3 Answers  

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

What is meant by a domain?

0 Answers  

For more Informatica Interview Questions Click Here
Categories