How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
Answer Posted / kishore
Very Simple guys....
Do a Override in SQ:
Select * from Tab1, Tab2
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are the restrictions of union transformation?
What is deployment group?
Why do you use Mapping Parameter and mapping variable?
What are the transformations that are not supported in mapplet?
What are ETL Tools?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
my source is junk data how will u remove that junk data by using unix please any one replay me
What is the sequence generator transformation in informatica?
What is the meaning of decode in informatica?
Explain sessions. Explain how batches are used to combine executions?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are batches?
Explain what are the different versions of informatica?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how