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?
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 informatica metadata and where is it stored?
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
what is pre and post sql and what is diff between source presql and target pre sql
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
permutations of mapplet
What are the Differences between static cache and dynamic cache?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
Design a mapping to get year of join for each employee.