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
- 8042 Views
- KPIT, I also Faced
- E-Mail Answers
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 |
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
Define Incremental Aggregation?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
difference between informatica 8.1.1 and 8.6
draw informatica architecture 8.6 ?
What is lookup change?
What is the Process to creating lookup transformation in informatica
What is joiner change?
If you want to create indexes after the load process which transformation you choose?
how can u approach u r client
What is partioning?how many types of partinings are there
Teradata 
