Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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

What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers  


What is active and passive transformation?

10 Answers  


What is lookup change?

0 Answers  


Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  


What are pre and post-session shell commands?

0 Answers  


In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,


How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  


Diffrence between static and dynamic cache

2 Answers   HCL,


What are Target Options on the Servers?

1 Answers  


what is the difference between repository & Intergration service

1 Answers  


If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,


Categories