I tried the SQ and linked directly from source to SQ only the required columns and generated workflow but it shows no result. Do I have to use any other transformation or do I have to add query in SQ if so how? help me thanks in advance.
I have found the solution no need to use join transformation since they are in parent child relationship. with my previous workflow it didn't show any error, executed fine but the issue is it didn't read any data from source tables hence no rows are inserted into target table
all I did is ,I jus specified the join condition in SQ itself now its working fine.