Interested to Buy Any Domain ? << Click Here >> for more details...
I want to run a workflow which consist of 3 sessions. But
wat my question is. 1st session should run on DB1if the
first session is successful then 2 session should run on
db2 and 3rd session should run on DB3 envronments. i want 3
different wf logs. it shoul not override on one log?
- 1 Answers
- 6407 Views
- I also Faced
- E-Mail Answers
Answer Posted / pooja
HI ALL,
CHANGE THE CONNECTION IN THE SESSION PROPERITES AND THE
WKFLOW MANGER USE DECSION TASK OR LINK CONDITION TO SPECFI
THAT IF 1ST SESSION RUN SUCCESSFUL THEN EXCUTE THE NEXT TASK
N CMING TO DIFFERENT WF LOG .
IN SESSION PROPERTIES YOU CHANGES THE SESSION LOG NAME AND
DIR... SO FOR EACH SESSION CHANNGE THE SESSION LOG NAME N
DIR......
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Enlist some properties of sessions.
How can we use batches?
What is option by which we can run all the sessions in a batch simultaneously?
What are active transformations.
What is incremental aggregation?
How can we store previous session logs?
Repository user profiles
How many types of sessions are there in informatica.please explain them?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to elaborate powercenter integration service?
State the limitations where we cannot use joiner in the mapping pipeline?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How do you load only null records into target?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
