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 |
1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
what is the difference between lookupoveride and joiner?
how can u avoid duplicate rows in flat file?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
What are the static cache and dynamic cache in informatica?
I have source like this 1:2;3. so i want to load the target as 123
what is plsql table?
What is Java Transformation? what are the uses of it?
without table how to come first record only in oracle?
What are the databases that informatica can connect to windows?