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 are factless facts? And in which scenario will you use such kinds of fact tables.

1817

---

Briefly describe lookup transformation?

1051

---

explain about unit testing? in real time?

2212

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8207

---

Explain what is informatica metadata and where is it stored?

1060

---

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

1989

---

write a query to retrieve the latest records from the table sorted by version(scd)

1080

---

Do you find any difficulty while working with flat files as source and target?

1111

---

How might one distinguish in the case of mapping is right or not without associating session?

1139

---

How do you handle two sessions in Informatica

1178

---

What are the guidelines to be followed while using union transformation?

1149

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1080

---

How to create the source and target database connections in server manager?

1101

---

How to load last n records of file into target table - informatica

1087

---

Explain why we use partitioning the session in informatica?

1105

---