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 Performance tuning in Informatica?
What are the mapings that we use for slowly changing dimension table?
What is domain and gateway node?
tell me 5 session failure in real time how can you solve that in your project?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
What is tracing level and what are the types of tracing level?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
Issue with Update override at Target table in Informatica.
In a sequential batch can you run the session if previous session fails?
What are the different types of olap? Give an example?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)