That is so ugly. What's wrong with two jobs?
I have to guess that dummy is a Transformer stage, and that the file to which you write in the sequential file stage downstream of dummy is not the same file read by this stage. Have you placed documentation in your job - ideally an annotation - alering future developers to this situation? Or are you violating the "law of least astonishment"?
Insert and update DB table fails when input umlaut character
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
arunpramanik
- Participant
- Posts: 63
- Joined: Fri Jun 22, 2007 7:27 am
- Location: Kolkata
Thanks Ray. We find that is the easiest way (in one job) to handle the overall DWH refresh as workaround; else creating two separate jobs and changing the job sequence of nearly 45 dimensions will take time to deliver, which we have to do eventually.ray.wurlod wrote:That is so ugly. What's wrong with two jobs?
Regarding dummy (that is the link) it will select some dummy count from a table and put it to a dummy sequential file.