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

Make a note of the quantity vaults made in informatica?

939

---

Explain lookup transformation in informatica

1001

---

What is joiner transformation in informatica?

992

---

What is different between the data warehouse and data mart?

998

---

How to differentiate between the active and passive transformations?

1068

---

What is the difference between router and filter?

1148

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1078

---

Write the unconnected lookup syntax and how to return more than one column.

1046

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5558

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1727

---

Explain sessions. Explain how batches are used to combine executions?

951

---

How to do unit testing in informatica?

1121

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2020

---

how to create user defined function (udf) in informatica

1237

---

what is the Default Source Option For Update Strategy Transformation?

1163

---