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
- 7398 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
What is the use of source qualifier?
How to create or import flat file definition in to the warehouse designer?
How to call shell scripts from informatica?
What are the new features of informatica 9.x at the developer level?
What are the performance considerations when working with aggregator transformation?
Why sorter is an active transformation?
What is meant by pre and post session shell command?
Define joiner transformation?
Where are the source flat files kept before running the session?
How does a rank transform differ from aggregator transform functions max and min?
Briefly describe lookup transformation?
What is a repository manager?
What is the use of code page?
What are mapplets? How is it different from a Reusable Transformation?
What are the various types of transformation?
