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

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

What is surrogate key?

9 Answers  

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

0 Answers   TCS,

plz plz plz send client names and project names in informatica?

1 Answers  

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

Explain in detail scd type 2 through mapping.

0 Answers  

What is aggregator transformation in informatica?

0 Answers  

How do you do error handling in Informatica?

1 Answers  

What are the mapping paramaters and mapping variables?

1 Answers  

For more Informatica Interview Questions Click Here
Categories