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??
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
Which transformation is needed while using the Cobol sources as source definitions?
What do you understand by a term domain?
Explain the features of connected and unconnected lookup.
Repository user profiles
What is the difference between informatics 7x and 8x and what is latest version?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is native users?
Explain in detail about scd type 1 through mapping.
Explain load alternative records / rows into multiple targets - informatica
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is union transformation in informatica?
What are the mapping parameters and mapping variables?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?