Hi........iam using dynamic RDBMS as a source for oracle database. I have two links going out from dynamic RDBMS stage. For each link i am using different sql queries. I want to know how i can execute a sql query for one link first and then go to the next link. i don't want both the links execute simultaneously.
any hints plzzzzzzzzz!
info for dynamic RDBMS
Moderators: chulett, rschirm, roy
Re: info for dynamic RDBMS
What you have is equal to having two different RDBMS stages in a job as sources.kirankota79 wrote:I want to know how i can execute a sql query for one link first and then go to the next link. i don't want both the links execute simultaneously.
If you are trying to split your process into 2 separate streams but want to have them in same JOB.
If you want to run one after the other one, think them as two different jobs, not sure what you are going to do after the read but you can do as belowRDBMS1 ------>
RDBMS2 -------->
dummy read could be from a file(/dev/null) or RDBMS(select x from dual).RDBMS1 ------>[rest of the job1]---->[dummy read]------>RDBMS2 -------->[rest of the job2]
~kris
~Kris
-
- Premium Member
- Posts: 315
- Joined: Tue Oct 31, 2006 3:38 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I am not sure if sparse lookup is the right way to go as your data volume is huge. Are both the links originating from the same schema? If yes then you can do a sql join. If they are in different schemas then probably best to do a join using the Join stage.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.