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
- 6645 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
What is target designer and target load order?
Explain lookup transformation source types in informatica
scenario where i can use only concurrent execution of workflow.
What are the performance considerations when working with aggregator transformation?
According to his methodology what all you need before you build a datawarehouse
What is powercenter on grid?
What is flashback table ? Advance thanks
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Explain why we use partitioning the session in informatica?
How to create Target definition for flat files?
What is complex mapping?
What is the Rank index port in Rank transformation?
What do you mean by worklet?
What are the types of caches in lookup?
How to improve the performance of a session using sorter transformation?
