i have two source data there is no pk,fk how to join the
two sources
Answer Posted / tauseef
if the two sources or coming from same datasource then we
can use source Qualifier trans to join
if it is coming from different then same add a dummy port on both the tables and join
if its wrong send me the soulution to my id tauseefwst@yahoo.com
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Performance tuning in UNIX for informatica mappings?
How does a sorter cache works?
How do you convert single row from source into three rows into target?
What is informatica metadata and where is it stored?
What is an expression transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How can you define user defied event?
How to load a Dimension ? and how to load a fact table?
What is the difference between informatics 7x and 8x and what is latest version?
How is union transformation utilized?
What is different between the data warehouse and data mart?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is dynamic cache?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Suppose we do not group by on any ports of the aggregator what will be the output?