Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 21 Answers
- 40666 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / srinu
Joiner :- Catch Performance will work based on
Master,Detail Column,Data catch,Index
catch ,Catch Size also.
(Process Begins with Condition,Comparing, Indexing)
No Catch :-With out Catch, its not easy find(5 records)
Relavtive Data.
Static ;- Catch will Keep the Target Rows to Compare with
Sourece Rows.
(Process Begin with Condition,Comparing).
Dynamic :- The Catch Data will be Update on DataFlow
also. ,,,
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is rank transformation in informatica
How are the sources and targets definitions imported in informatica designer?
Describe expression transformation?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
How are indexes created after completing the load process?
How do you convert single row from source into three rows into target?
What are active transformations.
Which transformation is needed while using the Cobol sources as source definitions?
Explain how many types of dimensions are available in informatica?
What is union transformation in informatica?
What are the prerequisite tasks to achieve the session partition?
How will the document be delivered to me?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is a transaction control transformation?
pmscmd startworkflow -sv
