Answer / vaibhav bhandeo

1. Run S3.
2. Connect it to S4 and S5. Check if PreviousTaskStatusS3 =
succeeded in the connecting link.
3. Once S3 is successfully executed it will start S4 and S5
4. Use a decision task and input that from S4 and S5. In
the decision use
PreviousTaskStatusS4 = succeeded or PreviousTaskStatusS5 =
succeeded
5. This will allow you to move ahead incase either of S4 or
S5 is succeeded.
6.Connect it to S1 using the same PreviousTaskStatus =
succeeded.
7.Connect it to S2 using the same PreviousTaskStatus =
succeeded.

This way the required job will be done.

Answer / pg

1. Create S3.
2. Connect it to S4 and S5 prallell. Check if
PreviousTaskStatusS3 =
succeeded in the connecting link.
3. Once S3 is successfully executed it will start S4 and S5
4. Connect s4 and s5 to session s1 and Check if
PreviousTaskStatusS3 =
succeeded in the connecting link and in general tab of
session choose the option treat
input rows as 'OR' .
5. This will allow you to move ahead incase either of S4 or
S5 is succeeded.
6.Connect it to S2 using the same PreviousTaskStatus =
succeeded in the lnk.

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  

---

Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?

5 Answers  

---

What is A complex mapping?

3 Answers   TCS,

---

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

---

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 Answers   IBM,

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  

---

can we use cartesian join in informatica

3 Answers   IBM,

---

 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,

---

What are the out put files that the informatica server creates during the session running?

2 Answers  

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---