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 / kumar
Hi Gurus,
can anyone please explain performance tuning above logic. If multiple sources are coming from multiple databases.
Not simple use Unioni/ Joinder T/R.
Please be patience.. your explanation is very helpful to us.
thanks in advance
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How might one distinguish in the case of mapping is right or not without associating session?
Why update strategy and union transformations are active?
What is the Rank index port in Rank transformation?
To import the flat file definition into the designer where should the flat file be placed?
What is union transformation?
Partition, what happens if the specified key range is shorter and longer
What is the difference between source qualifier transformations source filter to filter transformation?
can anyone explain me about retail domain project in informatica?
What are the popular informatica products?
what is degenerated dimension?
Can we create a Integration service without a Repository service and vice versa?
what are factless facts? And in which scenario will you use such kinds of fact tables.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What are the databases that informatica can connect to windows?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?