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
- 8396 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 |
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
Explain in detail about scd type 1 through mapping.
i have 2 session s1 execute s2 load first session fail what is the reason?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
What is sequence generator transformation in informatica?
what is system requirement(SR) & business requirement(BR)?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
How many repositories can we create in Informatica??
Teradata 
