top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Informatica: how to join two tables when there is no matching columns? What would be the approach?

+2 votes
496 views
Informatica: how to join two tables when there is no matching columns? What would be the approach?
posted Mar 2, 2016 by Sunil

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

We will create dummy port and data type is 1

answer Mar 3, 2016 by Manikandan J
Similar Questions
+1 vote

I have a flat file (source) with data that looks like this :
1,2,3
4,5,6

And a second flat file (source) that look like this:
1,2,3

I want result (target) to be a flat file that looks like this:
4,5,6

I know in SQL there is an EXCLUDE (opposite of INTERSECT) that would do the job. But I am doing this all with flat files and Informatica.

If anyone can tell what transformations should I use, that would be a great help.

+2 votes

I am trying to join 6 tables where 5 tables are located in Netezza database and the last table is present in SQL Server database. I need to join these six tables and extract all the required fields and load them into the target table which is located on Netezza.I tried writing SQL in SQL override to join all the tables but it throws me an error. Can someone help me how to resolve this issue?

Thank you.

+1 vote

I am trying to join 6 tables where 5 tables are located in Netezza database and the last table is present in SQL Server database. I need to join these six tables and extract all the required fields and load them into the target table which is located on Netezza.I tried writing SQL in SQL override to join all the tables but it throws me an error. Can someone help me how to resolve this issue?

+2 votes

Suppose we have a Source Qualifier transformation that populates two target tables. How do we ensure TGT2 is loaded after TGT1?

...