Answer Posted / arunakumari l

(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.

STEP1:
use this below logic in expression transformation:-

(variableports)curr_col1_val:column1

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

(variableports)pre_col1_val:column1

STEP2:
Take groupby on column2 in aggregator

What is the use of target designer?

1057

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4165

---

Where is metadata stored?

1118

---

How to delete duplicate row using informatica?

1051

---

What is intricate mapping?

1211

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2272

---

Which development components of informatica have the highest usage?

1048

---

What is a router transformation?

1132

---

Explain sessions and how many types of sessions are there?

1012

---

What is meant by lookup transformation? Explain the types of lookup transformation?

953

---

Explain the difference between a data warehouse and a data mart?

1060

---

What is the different lookup cache(s)?

1089

---

What is standalone command task?

1319

---

What is the format of informatica objects in a repository?

1021

---