Interested to Buy Any Domain ? << Click Here >> for more details...
How to Join Tables my Source is having 15 table target is
one?
- 4 Answers
- 8074 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 is difference between a gateway node and worker node?
How are indexes created after completing the load process?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What will be the approach?
What is a mapplet/worklet in informatica?
What is informatica?
can we override a native sql query within informatica? How do we do it?
Whats the difference between informatica powercenter server, repositoryserver and repository?
Clarify the utilization of aggregator cache record?
What is workflow manager?
How can we create index after completion of load process?
Explain pushdown optimization and types in informatica
What are multi-group transformations?
What is a passive transformation?
What is a sorter transformation?
