Session S1, S2, and S3. In the session S3 I want to load every
Saturday. How it is possible?
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 |
Briefly define reusable transformation?
What is Code Page Compatibility?
What is the Router transformation?
What are the mapping paramaters and mapping variables?
write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh
how we do performence tuning in informatica
explain about lookup t/r?
can we override a native sql query within informatica? Where do we do it?
What are the connected or unconnected transforamations?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks