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 |
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
In update strategy target table or flat file which gives more performance ? why?
What is the difference between bitmap and btree index?
What are the mapping parameters and mapping variables?
How can we get multiple output values using an unconnected lookup transformation?
What are active transformations? Name them.
How to merge First Name & Last Name?
HOW DO YOU PARFORM INCREMENTAL LAOD ?
Is stop and abort are same in informatica?
What is the capacity of power cube?
How do you do error handling in Informatica?
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