Hi,
We have a requirement like to have a generic job that handles taking data from a source ( here it is sql db) at run time. Here my question is whether is there any possibility to define metadata at run time, i mean to have a single job which can be used to extract data from different tables having different meta data.
if so please guide me in detail.
Regards,
Dinesh
Handling run time meta data
Moderators: chulett, rschirm, roy
Re: Handling run time meta data
Use RCP in the Input DB stage , parameterize the query and pass it at runtime(you may use parameter set)
But the good way is to create separate jobs for better maintainence.
But the good way is to create separate jobs for better maintainence.
Kiran Vaduguri
As soon as the fear approaches near, attack and destroy it.
As soon as the fear approaches near, attack and destroy it.
Re: Handling run time meta data
Hi,
if i am wrong please excuse, i understand that we can parameterize the query, but how do we go for metadata parameterization.
what i mean here is, as metadata is unique for each table and how do we download the metadata dynamically at run time.
Regards,
Dinesh
if i am wrong please excuse, i understand that we can parameterize the query, but how do we go for metadata parameterization.
what i mean here is, as metadata is unique for each table and how do we download the metadata dynamically at run time.
Regards,
Dinesh
As Kiran points out you use RCP. By selecting this datastage will automatically read in all the columns from the input stage/table/query.
As to what it selects will depend on your settings, query and the type of input stage. EG if you have a define statement saying select * from table with RCP turned on, it will extract all fields from that table. You may then have to surface different fields to assign them as key values (and you may have to find ways to parameterise the key values if they are different between tables).
I suggest you investigate and try using RCP and return if you have any further questions
As to what it selects will depend on your settings, query and the type of input stage. EG if you have a define statement saying select * from table with RCP turned on, it will extract all fields from that table. You may then have to surface different fields to assign them as key values (and you may have to find ways to parameterise the key values if they are different between tables).
I suggest you investigate and try using RCP and return if you have any further questions
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: