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
- 8306 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 |
Can we update the data in flat file using update strategy?
wat s mapping parameter and mapping variable? how do you set that in a mapping?
What are the measure objects?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query
what is mean by complex business rule ?
Differentiate between mapping parameter and mapping variable?
how can you load data into target table without leading zeor's
Can we insert ,update ,delete in target tables with one update strategy tran.?
How to create a non-reusable instance of reusable transformations?
What is substr in informatica?
In warehouses how many schemas are there?
Teradata 
