Why we select the table which has minimum number of records
as Master table in joiner?
Answer Posted / moorthy g
The Integration Service(IS) reads data from master table
and build data cahe and data index for building cache.
After that read data from detail table perform joins. bcz
routine will be very less(master means very less record
compared to detail table).
Finaly time saving. performance incresing.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is InformaticaPowerCenter?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain the types of transformations?
What is the need of an ETL tool?
What are the differences between source qualifier and joiner transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How to partition the Session?
What are the different lookup cache(s)?
what is the Default Source Option For Update Strategy Transformation?
How to convert multiple rows to single row (multiple columns) in informatica
What is decode in static cache?
What is an expression 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?
Is it possible to use a client with different version than that of its Informatica server?
How do you use reject loader.