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
What are ETL Tools?
What is the reusable transformation?
What is joiner transformation?
In informatica workflow manager, how many repositories can be created?
Please let me know how to make encryption and decryption with example?
Different circumstance which drives informatica server to expel records?
Define sessions in informatica etl?
What is difference between a gateway node and worker node?
What are the types of caches in lookup? Explain them.
What is workflow manager?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Enlist few areas or real-time situations where informatica is required.
What are the new features of Power Center 5.0?
How will the document be delivered to me?
On which transformations you created partitions in your project?