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
- 20511 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / gopi krishna k
write a pre sql which joins all 100 tables
Am I right?
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What are the steps involved in the migration from older version to newer version of Informatica Server?
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 .
What are the conditions needed to improve the performance of informatica aggregator transformation?
4 yrs etl devloper roles and responsibilities?any body give solutions
Whats there in global repository
What is sq transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What are mapplets?
Can anyone tell me the new features in Informatica 9 Version?
How we can use union transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what is the complex transformation you used in informatica
How to differentiate between the active and passive transformations?
What is enterprise data warehousing?
