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??
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 |
Label in Informatica. How to remove existing Label.
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
How can you increase the performance in joiner transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How to create a non-reusable instance of reusable transformations?
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?
tell me the push down optimization
What is query panel?
what is parallel querying and what r hints.
Can yoU use the maping parameters or variables created in one maping into another maping?