Answer Posted / s

INPUT
col1 col2
101 1000
101 1500
101 2000
102 1200
102 2300
102 3000
103 2400
103 1300
103 2000

OUTPUT
col1 col2
101 1000,1500,2000
102 1200,2300,3000
103 2400,1300,2000


SOURCE->SRT->EXP->TGT

SRT - Sort by column col1.
EXP - col1
col2
v_col2=iif(v_col1=col1,v_col2||','||col2,col2)
v_col1=col1
o_col1=v_col1
o_col2=v_col2

What is a standalone command task?

1142

---

Explain the code page compatibility?

1023

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2314

---

Enlist the differences between database and data warehouse.

1038

---

Explain the different lookup methods used in informatica?

978

---

What are the new features of informatica 9.x at the developer level?

989

---

What is the status code in stored procedure transformation?

1124

---

Explain the aggregator transformation?

1098

---

Explain sql transformation in script mode examples in informatica

1050

---

What is the command used to run a batch?

998

---

What is a transaction control transformation?

1146

---

Explain the scenario which compels informatica server to reject files?

1091

---

What is the function of aggregator transformation?

1022

---

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

1745

---

What do you mean by enterprise data warehousing?

1006

---