Answer Posted / hanan

src->exp->agg->tgt

src:-

In sql query write order by col1

exp:-

col1->
col2->
var_col2=iif(col1=var_col1,var_col2||','||col2)
var_col1=col1
output_port=var_col2

agg;-

select group by col1

tgt:-

connect to target

Explain in detail about scd type 1 through mapping.

1555

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628

---

Define update strategy?

1233

---

What are the types of schemas we have in data warehouse and what are the difference between them?

944

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1980

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1112

---

r u done any partitions in ur project?

1827

---

What is the procedure for creating independent data marts from informatica 7.1?

1067

---

What is a passive transformation?

1106

---

can anyone suggest best free Talend data integration training online

1694

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1060

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

1029

---

Explain the informatica workflow?

1074

---

Please let me know how to make encryption and decryption with example?

1905

---

What is substr in informatica?

1210

---