How to Join Tables my Source is having 15 table target is
one?
- 4 Answers
- 7281 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is status code in informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are different types of transformations available in informatica?
What do you understand by a term domain?
What are the tasks that source qualifier perform?
How can we store previous session logs?
How do you take back up of repository?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is Session and Batches?
How an expression transformation differs from aggregator transformation?
What is DR strategy for Informatica project?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is sq transformation?
