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
- 7929 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
Is it possible to define a single node as a Gateway node as well as worker node?
What is the difference between a connected look up and unconnected lookup?
What do you mean incremental aggregation?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
How would you copy the content of one repository to another repository?
How to partition the Session?
What are the different ways to implement parallel processing in informatica?
generate date / time dimension in informatica
can anyone explain me about retail domain project in informatica?
What does command task mean?
How does the aggregator transformation handle null values?
Describe the impact of several join conditions and join order in a joiner transformation?
Differences between connected and unconnected lookup?
Why sorter is an active transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
