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 / manish

we can use different target object for the same target table
and can load the data

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6767


How to update or delete the rows in a target, which do not have key fields?

664


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

571


What is a rank transform?

690


Define mapplet?

639






Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

755


What is a joiner transformation and why it is an active one?

590


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

708


Explain the etl program with few examples.

562


How you know when to use a static cache and dynamic cache in lookup transformation?

1357


Under what condition selecting sorted input in aggregator may fail the session?

679


what is SDLC way of code development?

1575


how to load rows into fact table in data warehouse

653


Enlist the differences between database and data warehouse.

574


what is Active lock explain

2384