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.

waht type of interface is used for testing the data in informatica

2005

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

878

---

What is a joiner transformation and why it is an active one?

769

---

In informatics server which files are created during the session rums?

855

---

How can we update a record in the target table without using update strategy?

894

---

Is there any way to read the ms excel datas directly into informatica?

761

---

Please let me know how to make Data masking in informatica..

1466

---

What is a predefined event?

845

---

How can you increase the performance in joiner transformation?

929

---

How can we use batches?

784

---

What is session task and command task?

841

---

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?

9352

---

How to call shell scripts from informatica?

755

---

What is the Process to creating lookup transformation in informatica

785

---

Where can we find the throughput option in informatica?

833

---