Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14 Answers
- 24229 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / tauseef
hai Taueef
As per above requirement my suggestion is
if the sources having similar columns then we go with union
if there is no similar columns add dummy port on all d source and use joiner transformation
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is InformaticaPowerCenter?
what is the hint? how to use it to reduce the query processing in program?
without table how to come first record only in oracle?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain the difference between a data warehouse and a data mart?
How to load the data from people soft hrm to people soft erm using informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
what is the Default Source Option For Update Strategy Transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is meant by target load plan?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What are the prerequisite tasks to achieve the session partition?
What is update strategy transform?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
