We can write source query in informatica wrapper script and store the query in variable and then pass the query variable in source qualifier query in mapping. So we can easily add new column or change query in wrapper script without changing mapping and we no need to refresh mapping also.
Wrapper Script SQLQUERY="SELECT EMPID,EMPNAME,EMPCITY FROM EMPLOYEE"
Source Qualifier $$SQL_QUERY -> Just pass this variable SQ in mapping.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!