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

What is exclusive and normal mode for repository services?

709


On which transformations you created partitions in your project?

759


Can you use flat files in Mapplets.

2213


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

546


what is index?how it can work in informatica

1576






without table how to come first record only in oracle?

1845


how we can load rejected record's at run time?(not through bad files)

1906


What are the components of Informatica? And what is the purpose of each?

614


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

629


What is fact table? Explain the different kinds of facts.

610


Describe data concatenation?

568


What is status code in informatica?

582


Explain Dataware house architecture .how data flow from intial to end?

2120


is it possible to index the data in cache of lkp transformation ?

1518


What does “tail –f” command do and what is its use as an Informatica admin.

627