Can PWC 9.1 create Target table dynamically when loading ?
I'd like to change the target table and create the table dynamically in each session.
My target db is Oracle 11g.
If PWC can do that, I'd like to use temporary table rather than normal table.
Thanks in advance,
In database target tables you can't create dynamically.
Incase of files you can create if you know the max number of columns for target table. based on that you can create & load the for required columns but this is not possible in realtime.
You can go through the following solution from Informatica Marketplace. You will also find over 400 mapping samples and many other useful tools on the same website.
I haven't tried to create target tables using informatica , but there is one approach which you can try i am not sure whether it will work or not , but trying doesn't harm anything.
1) You can use store_proc to create target table or any data base objects specifically use EXECUTE IMMEDIATE clause with in the procedure for dynamic sql , and insert the data using that same procedure only.
2) In next call check whether the table name exist or not and populate the data using store_procedure only.
If you have an other problem regarding store_proc creation i ll happy to help with.
Please respond whether it worked or not.
You can for example do either of the following:
At least these are two of the most commonly used approaches.