How to Join Tables my Source is having 15 table target is
one?
Answers were Sorted based on User's Feedback
First of all which type of sources yiu are using.
1)If all source types are same type of databases you can go
for joiner or SQ
2)If sources are diff types of databases u should go for joiner.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / moorthy g (ibm)
If your source is Flat file and Same Strcture then you can
go for indirect file type.
If source is relation file the you can use Source
Qualifier - Sql override or join condtion.
or Joiner Transformation(n-1)
=====
We Can join those tables in DB level.
(For Performance Tuning)
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
what is procedure to use mapping variable in source qualifier transformation? with example
Issue with Update override at Target table in Informatica.
how to run 2 workflows sequentially. plz respond what is the process?
what is the difference between mapplet & stored procedure?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
why we are using level option in normalizer transformation
Explain constraint based loading in informatica
How to import oracle sequence into Informatica?
What is the meaning of decode in informatica?
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
What is main use of mapplet?
What are the main issues while working with flat files as source and as targets ?