Interested to Buy Any Domain ? << Click Here >> for more details...
How can we join the tables if they don't have primary and
foreign key relationship and no matching port?
- 7 Answers
- 15631 Views
- I also Faced
- E-Mail Answers
Answer Posted / developer
use a union transformation if there are no matching ports.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Which transformation should we use to normalise the COBOL and relational sources?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is union transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is lookup transformation?
What is informatica?
what is unit testing?tell me proceedure
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the differences between source qualifier and joiner transformation?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
Explain the use of aggregator cache file?
What is the advantage of informatica?
Write the unconnected lookup syntax?
How many types of sessions are there in informatica.please explain them?
