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
- 8267 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define mapping and session?
what are the Methods For Creating Reusable Transformations?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
can you please explain me pre session and post session options?
How can one identify whether mapping is correct or not without connecting session?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is informatica? Why do we need it?
How do you convert single row from source into three rows into target?
what is index?how it can work in informatica
Design a mapping to load a target table with the following values from the above source?
What is the cumulative sum and moving sum?
How would you copy the content of one repository to another repository?
What is a dimensional model?
Can you generate sequence numbers without using the sequence generator transformation?
