Session S1, S2, and S3. In the session S3 I want to load every
Saturday. How it is possible?
Answer Posted / priyank
Hi,
We can use,
S1 --> S2 --> DECISION Task --> S3
CMD1 ------->
We will connect S2 and CMD1 to the DECISION Task. In CMD1,
we can give a unix script to check for current day and if
the day is not Saturday, then fail the command task.
In the DECISION task, we will give a condition,
S2.Status=Succeeded and CMD1.Status=Succeeded, then proceed
to S3.
Though I have given this solution, need to check on any
other more efficient method to achieve the given
situation.Will appreciate anyone coming up with a more
efficient solution.
Hope the above solution helps.
Thanks.
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
what is diff b/t sorter t/r and agg have the option sorter property...
What is the use of code page?
Enlist the various types of transformations.
Whats there in global repository
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are the restrictions of union transformation?
Scheduling properties,whats the default (sequential)
Define the various join types of joiner transformation?
How can you define user defied event?
What is dimensional table?
What do think which one is the better joiner or look up?
What is standalone command task?
What is domain and gateway node?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What you know about transaction control transformation?