How to Join Tables my Source is having 15 table target is
one?
- 4 Answers
- 7467 Views
- TCS, I also Faced
- E-Mail Answers
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 a filter transformation and why it is an active one?
In aggregator if u enable sorted input what will be the output and disable sorted wt is output
What are the different clients of powercenter?
To achieve the session partition what r the necessary tasks u have to do?
sorce is a flatfile only 1st and last row should insert to target how will u do?
whats the logic to load the lower level of granularity of data to fact table.
How many number of sessions can one group in batches?
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
What are session parameters ? How do you set them?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
Teradata 
