top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

0 votes

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.

posted Dec 15, 2014 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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

answer Dec 18, 2014 by Shweta Singh
Similar Questions
+1 vote

How to Import data from db2 table using informatica power Center without powerexchange.

+1 vote

I have two sources (source A and Source B), source B is an another one target table in my db. both are in diff user id . Now i have to transfer some data,s from these two sources to target table. Can i transfer data without using the joiner transfermation? how to do ?

+2 votes

I want to know how to rename the ODBC data source in informatica.

+1 vote

I want to know how to rename the ODBC data source in informatica.

+2 votes

I have 2 source tables:

table A: table B:

A_id || A_code           B_id || B_code 
-----  -------           -----  ------- 
2          t2            1      t1
3          t3            2      t2
4          t4            3      t3 

I want to join 2 table use Slowly change dimension

target table:

tgt_id || tgt_code || is_table A || is_table B
-----  ------------   -----------   ----------- 
1          t1         0              x 
2          t2         x              x   
3          t3         x              x
4          t4         x              0

I can't check type 'is_table A ' and 'is_table B' when join table.