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
- 6771 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 are the main features of Oracle 8i with context to datawarehouse?
Implementation methodology
What is meant by lookup transformation?
What is the need of an ETL tool?
Different circumstance which drives informatica server to expel records?
how to create user defined function (udf) in informatica
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How might one distinguish in the case of mapping is right or not without associating session?
Define filter transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the use of code page?
Explain the different lookup methods used in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
