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

can we create index and drop index in exsisting table while
using infomatica

Question Posted / d

Answers were Sorted based on User's Feedback



can we create index and drop index in exsisting table while using infomatica..

Answer / srinu

I know 4 ways in INFORMATICA

1)Source Analyzer window-
(source table,Using key ports(enable,disable)).
2)Source qualifie Trans-
(Sql override)
3)Target override
4)Pre sql,Post sql

Any corrections,, srinu.srinuvas@gmail.com .

Is This Answer Correct ?    11 Yes 0 No

can we create index and drop index in exsisting table while using infomatica..

Answer / roshan

one more way is to write stored procedure and use target pre load and target post load option using unconnected stored procedure T/R...
for more detail
infernonag@gmail.com

Is This Answer Correct ?    3 Yes 0 No

can we create index and drop index in exsisting table while using infomatica..

Answer / rekha

YES

Is This Answer Correct ?    3 Yes 1 No

can we create index and drop index in exsisting table while using infomatica..

Answer / amarnath

when you import a target into designer you have an option
to drop constraints or create it and some other options as
well. go and edit the target u will fins all the options.
u can drop constraints and index before loading and re-
create it after the load with these options. this is the
simple method provided by informatica.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

Explain dynamic target flat file name generation in informatica

0 Answers   Informatica,

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

Is it possible to revert a global repository to local one and why?

0 Answers  

one source to target loading insert new rows and update existing rows?

3 Answers   Polaris,

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  

Make a note of the quantity vaults made in informatica?

0 Answers  

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

How do you take back up of repository?

0 Answers  

What is a node in Informatica?

0 Answers  

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories