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

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1171

list out all the transformations which use cache?

1184

How to create a non-reusable instance of reusable transformations?

1135

How might one distinguish in the case of mapping is right or not without associating session?

1123

How does the aggregator transformation handle null values?

1149

What is the function of aggregator transformation?

1085

What is session task and command task?

1299

What is workflow monitor?

1062

What are the different types of transformation available in informatica.

1105

Please let me know how to make Data masking in informatica..

1726

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1279

Is it possible to revert a global repository to local one and why?

1081

Slowly changing dimensions, types and where will you use them

1714

Explain Dataware house architecture .how data flow from intial to end?

2584

What are the tuning techniques you applied during your last project

2026