if you have same meta data in all 15 tables, then you can join those tabl

How to Join Tables my Source is having 15 table target is
one?

Question Posted / balu024

Answer Posted / balu024

if you have same meta data in all 15 tables, then you can join
those tables by using union transformation

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1968

Slowly changing dimensions, types and where will you use them

1669

what is mean by complex business rule ?

2123

What are the differences between joiner transformation and source qualifier transformation?

1106

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1746

Explain direct and indirect flat file loading (source file type) - informatica

1275

Does an informatica transformation support only aggregate expressions?

984

Explain lookup transformation in informatica

1021

write a query to retrieve the latest records from the table sorted by version(scd)

1022

Where do we use mapping variables in informatica?

1007

Explain lookup transformation source types in informatica

1052

What is the way to execute pl/sql script using informatica mapping?

1528

How to elaborate tracing level?

1123

How do you load unique records into one target table and duplicate records into a different target table?

1173

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1114