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



Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?..

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

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?..

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

Post New Answer

More Informatica Interview Questions

1)what is the use of bottlenecks in informatica. 2)where we are use shellscripting. 3)what meant by informatica.

1 Answers   CTS,


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

1 Answers   Infosys, Saksoft,


what is the difference between lookupoveride and joiner?

3 Answers  


how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,






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?

10 Answers   Wipro,


What are the static cache and dynamic cache in informatica?

0 Answers  


I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,


what is plsql table?

2 Answers  


What is Java Transformation? what are the uses of it?

0 Answers   TCS,


without table how to come first record only in oracle?

0 Answers  


What are the databases that informatica can connect to windows?

0 Answers  


Categories