Interested to Buy Any Domain ? << Click Here >> for more details...
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??
- 1 Answers
- 7959 Views
- KPIT, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How to open an older version of an object in the workspace?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Plz can any one say me how to get the informatica certification materials and dumps
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Can anyone tell me the new features in Informatica 9 Version?
Can we override a native sql query within informatica?
What are the differences between joiner transformation and source qualifier transformation?
What are the reusable transformations?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What differs when we choose the sorted input for aggregator transformation?
What are batches?
Mention some types of transformation?
What do you understand by SOA of Informatica?
server hot-ws270 is connect to Repository B. What does it mean?
