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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Session S1, S2, and S3. In the session S3 I want to load every
Saturday. How it is possible?

Question Posted / jey.dgl

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 batches?

0 Answers  

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

what is lookup chache?

1 Answers   Patni,

What are the unsupported repository objects for a mapplet?

1 Answers   Informatica,

what is degenerated dimension table with scenario

2 Answers   HCL,

how to move the mappings from your local machine to claint place?

2 Answers  

What is workflow? What are the components of workflow manager?

0 Answers  

what is the gap analysis?

1 Answers  

Describe two levels in which update strategy transformation sets?

1 Answers  

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

How can we update a record in the target table without using update strategy?

0 Answers  

What do you mean by blocking transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories