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
How to partition the Session?
What are active transformations.
r u done any partitions in ur project?
What is repository manager?
What are the features of complex mapping?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to create Target definition for flat files?
What is a difference between complete, stop and abort?
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 many transformations can be used in mapplets.
can you please explain me pre session and post session options?
What is workflow manager?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is informatica?
What is meant by active and passive transformation?