Answer Posted / sushma

SOURCE--->SOURCE QUALIFIER ----> EXPTRANS1 -----> FILTER ---
--> EXPTRANS2 ------> TARGET

In EXPTRANS1, concatenate X1 and X2 values for every 2nd
record (ie X= X2). Lets call this output column as
x1x2_value
Note: I am concatenating for every second record as X1 and
X2 appear alternatively In your sample data,

In the filter transformation, have the filter condition
X='X2' (only these recs have the concatenated data)

In EXPTRANS2, Using substr to split the data into X1 and X2
and load it into target table

what is the size of your data warehousing?

1669

---

tell me 5 session failure in real time how can you solve that in your project?

1629

---

How can we use mapping variables in informatica?

597

---

How to Create a folder using pmrep command?

618

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1527

---

---

Make a note of the quantity vaults made in informatica?

551

---

Is stop and abort are same in informatica?

568

---

What is a joiner transformation?

549

---

How big was your fact table

1310

---

What is incremental aggregation?

570

---

Differences between connected and unconnected lookup?

606

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3319

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

889

---

How to update or delete the rows in a target, which do not have key fields?

651

---

Explain sessions?

602

---