I have to join 2 Different Tables of 2 Different Database. One from SQL Server and other is from Oracle. Now In Informatica we used 1 Dummy Column each for 2 and joined them. After Both database Input Components I kept tReplace to Replace a String each. Now when I am joining them in tmap creating 1 Dummy Column each for both Input Sets it is saying Dummy Columns can't be resolved or is not a variable. I have to filter out data after tmap in below way
(TO_DATE(Date Column of SQL SERVER,'YYYY-MM-DD') >= DATE COLUMN OF ORACLE and TO_DATE(Date Column of SQL SERVER,'YYYY-MM-DD') <= DATE COLUMN OF ORACLE) AND UPPER(Brand column of SQL server)=UPPER(BRAND Column of Oracle Table). If anyone can help will be really helpful to him
I'm not sure why you are using "Dummy Columns", is there not a natural key field which will help you join? Maybe if you show me your job design it will help me understand the issue. If you can do it in Informatica, you can do it in Talend...but not necessarily in the same way.
actually There is no such column to join between Them.So creating Dummy Columns.
tmssqlinput(select columns from Table)--->treplace(replacing a string)--->
toracleinput(select columns from Table)--->treplace(replacing a string)--->tmap(joining on those 2 Dummy Columns)----Have to filter out based on my condition----
Now joining is happening. But unable to do the Filtering.
After tmap I have to do a filter in below way(which we did in Informatica)
(TO_DATE(Date Column of SQL SERVER,'YYYY-MM-DD') >= (DATE COLUMN OF ORACLE which is in MM/DD/YYYY Format) and TO_DATE(Date Column of SQL SERVER,'YYYY-MM-DD') <= (DATE COLUMN OF ORACLE which is in MM/DD/YYYY Format)) AND UPPER(Brand column of SQL server)=UPPER(BRAND Column of Oracle Table).
