Answer Posted / dhanakkodi

I have two tables emp and dept

i want some employees those who are in the some department
for this situation i have to join two tables.
In this situation both table foreign keys are in the Fact
table means we can easily get the information and also
factless fact table is used for get the count from the
table.

-- Dhanakkodi

What is sequence generator transformation in informatica?

1122

---

What is intricate mapping?

1310

---

Explain lookup transformation is active in informatica

1147

---

What is informatica worklet?

1115

---

Enterprise data warehouse your projects phase by phase explain?

1964

---

Explain the use of aggregator cache file?

1316

---

What is the way to execute pl/sql script using informatica mapping?

1681

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1148

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10727

---

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

2596

---

What is a dimensional model?

1033

---

What is the maplet?

1202

---

Explain the tuning lookup transformation - informatica

1043

---

can u any challenge your project?

2083

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7498

---