i have different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task

Answer Posted / pentaho

v can use user define join ........

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data caches/ index caches?

798


How do you load only null records into target? Explain through mapping flow.

1758


What is the use of transformation?

760


where to store informatica rejected data? How to extract the informatica rejected data?

776


How do you load only null records into target?

942


Differentiate between reusable transformation and mapplet.

834


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8020


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1411


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1237


differences between service based and product based?

1765


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?

762


Write the unconnected lookup syntax and how to return more than one column.

825


How many number of sessions can one group in batches?

894


What are the popular informatica products?

797


What is the need of an ETL tool?

834