Interested to Buy Any Domain ? << Click Here >> for more details...
Session S1, S2, and S3. In the session S3 I want to load every
Saturday. How it is possible?
- 2 Answers
- 8260 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / anindita
I would change the link condition from S2 --> s3.
I'll format the Sysdate to return 'DAY' and then check if that is equal to Saturday, if that is true link condition is true else false.
| Is This Answer Correct ? | 3 Yes | 0 No |
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
How to delete the (flat file) data in the target table after loaded.
what are 3 tech challenges/ common issues you face?
What is joiner transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
What do you understand by a term domain?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
What is a code page?
how u know when to use a static cache and dynamic cache in lookup transformation.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Teradata 
