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
- 24412 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / nitin tomer
Best solution as per my knowledge is below, i am assuming all tables are in DB.
1)Create a meta data table in your target DB with the three columns source_table_name,Target_table_name and Flag.
2)Use SQL transformation in informatica in Query Mode and give the required connections
3)Configure the SQL transformation and give the generic queries
create table ~Target_table_name as select * from ~source_table_name;
~source_table_name and ~Target_table_name: It will take from the meta data table
In this way you can automate this process and can load as many tables you want just you have to give table name entry in meta data table.
Write me @thisistomer@gmail.com if you have any doubts.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
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 different versions of informatica?
Repository user profiles
Mention some types of transformation?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
COM components can be used in Informatica
what is unit testing?tell me proceedure
Explain sessions?
Reusable transformation and shortcut differences
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Which development components of informatica have the highest usage?
What are the differences between joiner transformation and source qualifier transformation?
explain about unit testing? in real time?
