How to Join Tables my Source is having 15 table target is
one?

Answer Posted / suneel kumar

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about Informatica server process that how it works relates to mapping variables?

714


Why do we need informatica?

643


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1735


Why is sorter an active transformation?

758


Enlist the advantages of informatica.

728






suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6319


What is meant by a domain?

743


what is index?how it can work in informatica

1695


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1630


What is informatica? Why do we need it?

742


Explain incremental aggregation in informatica

746


Can we create multiple integration service on single repository?

801


What is sequence generator transformation in informatica?

714


Could you explain what is enterprise data warehouse?

646


Why do you use Mapping Parameter and mapping variable?

1377