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
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,
How to update or delete the rows in a target, which do not have key fields?
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?
What is a rank transform?
Define mapplet?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is a joiner transformation and why it is an active one?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Explain the etl program with few examples.
How you know when to use a static cache and dynamic cache in lookup transformation?
Under what condition selecting sorted input in aggregator may fail the session?
what is SDLC way of code development?
how to load rows into fact table in data warehouse
Enlist the differences between database and data warehouse.
what is Active lock explain