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
- 6695 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 |
what is the look up transformation?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
What are the differences between source qualifier and joiner transformation?
Diffrence between static and dynamic cache
How to recover the standalone session?
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
What is the benefit of session partitioning?
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
what is the size of your data warehousing?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
How to extract the informatica rejected data?
How to load a Dimension ? and how to load a fact table?
Teradata 
