Answer Posted / balaganesh

SQ-->SRT-->EXP-->AGG-->TGT

In SRT:
sort the record by col1 (Ascending)

In Exp:
col1
col2

v_col2=iif(v_col1=col1,v_col2||','||col2,col2)
v_maxcount=iif(v_col1=col1,v_maxcount+1,1)
v_col1=col1
o_col1=v_col1
o_col2=v_col2
o_maxcount=v_maxcount

In AGG:
Group by o_col1
MAX(o_maxcount)

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

1959

---

Where do we use mapping variables in informatica?

1076

---

What do you mean by enterprise data warehousing?

1072

---

What do you understand by term role-playing dimension?

1058

---

Can we create a Integration service without a Repository service and vice versa?

1221

---

How can we handle two sessions in informatica?

1041

---

What are the designer tools for creating transformations?

1126

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1815

---

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,

7195

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2351

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4118

---

Different circumstance which drives informatica server to expel records?

992

---

How can we use mapping variables in informatica?

1071

---

What is domain in terms of informatica?

1013

---

What is the difference between a connected look up and unconnected lookup?

972

---