Tanubhrt.This.Side

Often when learning Informatica, you are told that once you create the table in the Target Analyzer you need to go to the Target tab and generate and execute the SQL.

But do you know why are you doing it?? I mean you have created the table in Informatica and so you will be able to make the mapping, but then why??

When you generate and execute SQL and create the table, you are actually creating the table in the SQL or for that case any database that you are using. This means that on clicking generate and execute table you are actually running the create table query in your database.

Now, when you are finished off with your mapping and you have mapped the source(before or after transformation) your target table, you have actually inserted the changed data into the table i.e. your table in the database.

Now, once you are done with this, when you run the workflow, Informatics is going to search for the table in the database and you need your target table there.

If you already have the target table in the database, you need not to do the Generate Execute thing. So, the choice is yours, either create the table using the query in the database itself or click on the generate and execute button.

If you have any queries comment below 🙂

Happy Learning 🙂