Informatica: How to import data from 2 table(parent and child table)?

Question

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.

Answer 1

Try this, Parent Table To Source Qualifier(Parent) & Child Table To Source Qualifier(Child)

Next, Join both Source qualifiers based on a join condition using Join Transform (or) If you want to Union both data sets then use Union transoform

Next, Use expression transform for cleaning,filtering data or to apply any logic

Last, Map the expression transform to load the Target table