from Source 100 rows are coming, on target there are 5 m
rows which options is better to match data
1. Joiner
2 No cache
3. Static
4. Dynamic
Answer Posted / prakash
USE NOCACHE,IT WILL GIVE BETTER PERFORMANCE RATHER THAN
JOINER
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain in detail scd type 2 through mapping.
r u done any partitions in ur project?
How to delete duplicate row using informatica?
What is session task and command task?
What are the restrictions of union transformation?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How we can create indexes after completing the loan process?
How do you promote a non-reusable transformation to reusable transformation?
During the running session, output files are created by informatica server. Enlist few of them.
How do you migrate data from one environment to another?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Is there any target staging area in informatica not staging area
Mention few power centre client applications with their basic purpose?
what is informatica metadata?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?