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
- 6875 Views
- Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anu
IF 2 SOURCES ARE RELATIONAL USE SQ T/R
WRITE MANUVAL QUERY
first connect requrired 16+1 attributes to furter t/r or target
select required columns and in where condition write matched condition
if there is no common column go to joiner create sequence in both sources then compare sequence in join vondition
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
What exactly mentioned in High level design document.can somebody explain me sequentialy.
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
If informatica has its scheduler why using third party scheduler?
What are the different types of Type2 dimension maping?
which is better perfomancewise lookup or joiner and why?can anyone give example?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
How do you do error handling in Informatica?
How many transformations can be used in mapplets.
in my lookup table i want to catch the recently updated records from the source to target,how to achieve this and what is last commit interval point for this?
How many ways are there to do 'remove duplicate records in informatica'?
Teradata 
