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 / bsgsr
after reading the above answers i find one is left joining
the tables in the database itself rather than joinng them
in the session using 99 joiners. it would also increase
performance.
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How to load the data from a flat file into the target where the source flat file name changes daily?
Explain the aggregator transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Separate from a database, an information bazaar, and an information stockroom?
What are the settings that you use to configure the joiner transformation?
what is Active lock explain
Explain the difference between a data warehouse and a data mart?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What are some examples of informatica etl programs?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain why we use partitioning the session in informatica?
What is workflow manager?
what are 3 tech challenges/ common issues you face?
How can we update a record in the target table without using update strategy?
Explain sessions?