Answer Posted / sumana

Hi i have a samll doubt on this
Three dimensions are in same mapping but three different
flows. 3 diffrent flows means when the first completes then
only the second flow will start in this case by use one
sequence generator how will we pass the same values to all
the three dimensions. The surrogate key value should pass
like this for all the dimensions

dim1 dim2 dim3
---- ---- -----
1 1 1
2 2 2
3 3 3
4 4 4

What is persistent lookup cache?

1029

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2122

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1083

---

what is mean by complex business rule ?

2162

---

What are the measure objects?

1202

---

Differences between connected and unconnected lookup?

1218

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1257

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1708

---

Differentiate between joiner and lookup transformation?

1102

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2199

---

what is the complex transformation you used in informatica

2587

---

What is informatica powercenter repository?

1202

---

Define sessions in informatica etl?

1034

---

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

1058

---

Where is metadata stored?

1113

---