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
- 21316 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / rachana
Use a Joiner Transformation to join the tables and load
into single target. Joiner tarnsformation can join
heterogenous sources
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What the difference is between a database, a data warehouse and a data mart?
what is Active lock explain
Mention few power centre client applications with their basic purpose?
what are the Methods For Creating Reusable Transformations?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How are the sources and targets definitions imported in informatica designer?
What is meant by lookup transformation? Explain the types of lookup transformation?
Where is metadata stored?
Explain sessions?
What are ETL Tools?
Explain what are the different versions of informatica?
Can we create two repositories on same database instance in oracle?
what is size of u r database?
Explain what transformation and how many are there in informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
