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
- 8206 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 |
Design a mapping to load the cumulative sum of salaries of employees into target table?
which is better perfomancewise lookup or joiner and why?can anyone give example?
What are the different types of Type2 dimension maping?
What are the types of maping wizards that r to be provided in Informatica?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Explain incremental aggregation in informatica
What is source qualifier transformation in informatica?
What is staging area?
Do joiner transformation use cache? If so describe?
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
Teradata 
