How to Join Tables my Source is having 15 table target is
one?
- 4 Answers
- 7000 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
What differs when we choose the sorted input for aggregator transformation?
How to differentiate between the active and passive transformations?
Mention few advantages of router transformation over filter transformation.
What are mapplets? How is it different from a Reusable Transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain constraint based loading in informatica
Difference between Target-based loading and constraint-based loading?
Slowly changing dimensions, types and where will you use them
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Write the program through which the records can be updated?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Differentiate between reusable transformation and mapplet.
What is a transaction control transformation?
Explain pmcmd command usage in informatica
Write the advantages of partitioning a session?
