Interested to Buy Any Domain ? << Click Here >> for more details...
Hi I have two sources like A, B. My source A contain 10000
million records from that i need 20 attributes. My source B
has also same 10000 million records from that i need only 1
attribute. By using Joiner i have to load into target? Is
there any issue regarding this? if issue is there how to
tune this mapping in best way?
- 2 Answers
- 6739 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / muni
take B table as master....A table as a detail.... so we can reduce serch process in joiner
than based on which column we are going to do join create a index on it
i hope it will give gud per'mance
if i i am worng plz create it
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
what are 3 tech challenges/ common issues you face?
Enlist some properties of sessions.
What are junk dimensions?
In informatica workflow manager, how many repositories can be created?
How might one distinguish in the case of mapping is right or not without associating session?
what is SDLC way of code development?
What is a stored procedure transformation?
What do you mean by enterprise data warehousing?
How you know when to use a static cache and dynamic cache in lookup transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Where are the source flat files kept before running the session?
How many ways are there to do 'remove duplicate records in informatica'?
What are the performance considerations when working with aggregator transformation?
