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
Can you help me in filtering?actually have very less knowledge with this function.
TalendDate.compareDate(myDate,myDate2,"MM/dd/yyyy")>0 is it something like be?
Now MyDate2 is coming from SQL SERVER. which is in yyyy-MM-dd and myDate is in MM/DD/YYYY format. so what will be the filtering condition which we used in Informatica?
(TO_DATE(Date,'YYYY-MM-DD') >= FROM_DATE and TO_DATE(Date,'YYYY-MM-DD') <= TO_DATE)
