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

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

can anyone suggest best free Talend data integration training online

0 Answers  

What is a stored procedure transformation?

0 Answers  

How i can upload the MainFrame source For Informatica ?

1 Answers  

what is lookupoverriding?

1 Answers  

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

Explain what are the different versions of informatica?

0 Answers  

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

What is the difference between informatica 7.0 and 8.0?

0 Answers  

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,

What is a router transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories