How to track which ETL job is loading 1 particular DB table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, using Save from a job design also establishes a linkage that Usage Analysis and other analyses can use. (However it does not save format information for sequential files.)DSer wrote:Can we save the metadata definitiona at a later stage and use this method?
During the Save dialog be systematic about your categories - don't simply dump everything into the Saved category!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Before you have saved, NO.
After you have saved, YES. Even for extant jobs.
Going forward, learn to Import then Load, rather than need to Save. You will make fewer mistakes in this way.
After you have saved, YES. Even for extant jobs.
Going forward, learn to Import then Load, rather than need to Save. You will make fewer mistakes in this way.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
Wnat to the table names
Hi,
I have a list of inactive jobs in the project.
I want to know the tables these jobs are using.
the tables may be source or target tables.
and the tables are teradata enterprise stages.
How do i get the list of tables in the project.
Thanks,
Samyam
I have a list of inactive jobs in the project.
I want to know the tables these jobs are using.
the tables may be source or target tables.
and the tables are teradata enterprise stages.
How do i get the list of tables in the project.
Thanks,
Samyam
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 258
- Joined: Tue Jul 04, 2006 10:35 pm
- Location: Toronto
The SQL in
viewtopic.php?t=99543
Will find any string in a job. Use it and see if you cannot find all the jobs using a specific table.
viewtopic.php?t=99543
Will find any string in a job. Use it and see if you cannot find all the jobs using a specific table.
Mamu Kim