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

1:when we develop a project what are the performance issue
will raise?? KPIT
2:if a table have INDEX and CONSTRAINT why it raise the
performance issue bcoz when we drop the index and disable
the constraint it performed better??KPIT
3:what are unix commands frequently used in informatica??

Question Posted / himansu


1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have IND..

Answer / srinu

Hai KPIT,, My Ans will Show you the Way,,,,,,

1) Performance Issue in Informatica: In your
Project ,My Project,,,Any Project Mostly our final
Target was Loading the Data in to Target Table, under
Efficiently in Less time.
Tune the Mapping, Less Active Transformations,Use Best
Loading Option,
Partition the Data,Index less Target Table,,,,,


2)Yes, we drop the index and disable the constraint Perform
Better,That loads the Data based on the Particicular Table
only,Else I will go for Parent,Child test in FK
Relation,Condition in constraint,,,After Loading the Data
You can Configure indexes, constraints on Table.


3)SED-commands,AWK-commands,Dir Commands,File Commands,Copy
Commands only,,

Thanks
Srinu.srinuvas@gmail.com

Is This Answer Correct ?    3 Yes 3 No

Post New Answer

More Informatica Interview Questions

what is the difference between stop and abort?

3 Answers   TCS,

design of staging area?

0 Answers  

What are the differences between a connected lookup and unconnected lookup?

0 Answers  

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,

In how many ways we can create ports?

0 Answers  

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

What is A cache?

2 Answers  

can u any challenge your project?

0 Answers   HP,

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

0 Answers  

Briefly describe lookup transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories