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
- 8045 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 are the deliverables?in your project?
Differentiate between a repository server and a powerhouse?
What are some examples of informatica etl programs?
What is the use of transformation?
What is option by which we can run all the sessions in a batch simultaneously?
What are the different types of olap? Give an example?
Write the program through which the records can be updated?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to convert multiple rows to single row (multiple columns) in informatica
How to extract sap data using informatica?
Repository user profiles
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to handle decimal places while importing a flatfile into informatica?
Explain the scenario which compels informatica server to reject files?
What is the use of code page?
