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.

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2101

---

What is sequence generator transformation in informatica?

1119

---

How many input parameters can exist in an unconnected lookup?

1598

---

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?

10309

---

what is size of u r database?

2362

---

What are the different options available for update strategy?

1047

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1907

---

In warehouses how many schemas are there?

1126

---

Is stop and abort are same in informatica?

1039

---

What are the differences between oltp and olap?

1015

---

Different sorts of metadata that stores in the storage facility?

1069

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2403

---

What are the designer tools for creating transformations?

1155

---

What is domain and gateway node?

1203

---

What do you understand by SOA of Informatica?

1039

---