Search results for query: *

Let me try to make this discussion on more concrete terms. Let's say the mapping variable is $$RowKount. Let's say you want to reset or initialize $$RowKount to 0 every time you start a session. You can put an entry $$RowKount=0 in the parameter file you start the session with. Then the...

Below is my understanding -- if it is wrong then I like to know that it is wrong. Let's say you have a mapping variable $$RowKount and you have an entry in the parameter file like: $$RowKount=0 then the $$RowKount variable will be initialized to 0 for the each session using the parameter file...

Smajay, Yes! You hit a home run. I have submitted a vote for you to be TipMaster of week. Thank you.

Kublait, You helped a lot. Thank you. I am really intrigued by the idea of putting the SCD_load and Fact_load in the same batch (as compared to putting SCD_load in the same batch as the other Dimensions). Is there some general rationale for this that you would share? And, in that batch, do...

That is why I am asking for help here: I looked and could not find clear, definitive instructions. This is what the v5.1 manual says: The Informatica Server marks a batch as failed if one of its sessions is configured to “run if previous completes” and that previous session fails. If you use...

Kublait, Thank you for the information. I believe you are illustrating the steps in version 6, because I haven't seen the terms "workflow" and "command task" used in version 5.1. Do you happen to know the steps for version 5.1? I have an additional question re your 4-batch illustration. Was...

In loading a star schema, we need to load the Dimensions before the Fact. According to the manual, we can configure the Fact session as "Run if Previous Complete" -- Don't start the Fact session if the Dimensions failed to complete. I have not found any instruction on how to set this up...

This is a different and very basic question regarding scheduling Informatica sesions. Hope someone will help me. In loading a star schema, we need to load the Dimensions before the Fact. According to the manual, we can configure the Fact session as "Run if Previous Complete". Please help me...