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.

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1158

---

What is parallel processing in informatica?

1698

---

Can we create multiple integration service on single repository?

1180

---

Can u generate reports in Informatica?

1075

---

Can anyone tell me the new features in Informatica 9 Version?

2117

---

Define sessions in informatica etl?

1027

---

What is a dimensional model?

974

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1257

---

Which transformation should we use to normalise the COBOL and relational sources?

1192

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1102

---

What are ETL Tools?

1109

---

What is exclusive and normal mode for repository services?

1134

---

What are the different lookup cache(s)?

1108

---

What is meant by lookup transformation?

1094

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2057

---