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.

How do you convert single row from source into three rows into target?

1091

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1842

---

explan ur project architecture?

2005

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2179

---

What is dimensional table?

1002

---

can u give example for factless fact table

6441

---

Separate from a database, an information bazaar, and an information stockroom?

1011

---

How can a transformation be made reusable?

1077

---

What is union transformation in informatica?

1097

---

What is the function of look up transformation?

1054

---

What is session task and command task?

1176

---

How can we handle two sessions in informatica?

982

---

How would you copy the content of one repository to another repository?

949

---

Briefly define reusable transformation?

1075

---

What is event and what are the tasks related to it?

1054

---