Answer Posted / arunakumaril

(here column names are not mentioned .so,i have taken them
as column1 and column2)

take 2 variables for current value of column1 and previous
value of column1 and use concat function for concatenating
values of column2.

(variableports)curr_col1_val:column1

(variableports)res:if(curr_col1_val=pre_col1_val,concat
(res,column2),column2)

(variableports)pre_col1_val:column1

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1197

---

What is mapplet in informatica?

982

---

What is the meaning of up gradation of repository?

1896

---

What is a pre-defined event and user-defined event?

972

---

What is resilience time?

1047

---

What is the use of source qualifier?

1070

---

How to delete duplicate row using informatica?

982

---

What is target designer and target load order?

1051

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1885

---

How to implement security measures using repository manager?

1082

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2098

---

design of staging area?

1964

---

What do you understand by a term domain?

1062

---

What does refresh system mean, and what are its distinctive choice?

1072

---

Why filter transformation is an active one?

929

---