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

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com

0 Answers  

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 Answers   IBM, ITC Infotech,

i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

How do you load only null records into target? Explain through mapping flow.

0 Answers  

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

Why sorter is an active transformation?

0 Answers   Informatica,

What is rank transform?

0 Answers  

What is a data modeling?

2 Answers  

For more Informatica Interview Questions Click Here
Categories