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
- 6870 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
difference between informatica 8.1.1 and 8.6
What does “tail –f” command do and what is its use as an Informatica admin.
How to update source definition?
How are the sources and targets definitions imported in informatica designer?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Is there any way to read the ms excel datas directly into informatica?
What do you understand by term role-playing dimension?
Explain the difference between mapping parameter and mapping variable?
How many types of sessions are there in informatica.please explain them?
can we override a native sql query within informatica? How do we do it?
How can you generate reports in informatica?
update strategy transformation in informatica
What is rank transformation?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is joiner transformation in informatica?
