Hello Friends.
I have encountered a situation.
I want to pull the data from a webpage, using any transformation I have to load the data into target ( Oracle, DB2, Teradata, Flat File or XML File) Any format is fine.
The data will be updated every day on the webpage.
so I have to extract that data using any transformation and load it to any format.
Please suggest me a solution. I thought of using HTTP transformation. Please let me know how to set paramaters, etc. Can you explain step by step.
Can you send me step by step solution, because I never did such type of ETL.
Can you tell me the step by step apporach, i.e how to do it using informatica what transformations I have to use, what paramaters I have to set. And how can I save a web page as xml. Can you please let me know how to do that.
Thank You
Regards
J
I have encountered a situation.
I want to pull the data from a webpage, using any transformation I have to load the data into target ( Oracle, DB2, Teradata, Flat File or XML File) Any format is fine.
The data will be updated every day on the webpage.
so I have to extract that data using any transformation and load it to any format.
Please suggest me a solution. I thought of using HTTP transformation. Please let me know how to set paramaters, etc. Can you explain step by step.
Can you send me step by step solution, because I never did such type of ETL.
Can you tell me the step by step apporach, i.e how to do it using informatica what transformations I have to use, what paramaters I have to set. And how can I save a web page as xml. Can you please let me know how to do that.
Thank You
Regards
J