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
- 7518 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 |
What is intricate mapping?
How to generate sequence numbers?
What is Target Update Override? What is the Use ?
what is confirmed fact?
Explain dynamic target flat file name generation in informatica
Types of error logs in Informatica?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
Why we require dwh in particular projects?
What is domain in terms of informatica?
Can I create one wrkflw which will run different wrkflws on schedule time?
Whats the difference between informatica powercenter server, repositoryserver and repository?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
Teradata 
