Answer Posted / bhupal

if you use the update strategy transformation before joiner in mapping, the mapping will be invalid because of data flow validation errors in mapping irrespective of operations you implemented in update strategy.

joiner transformation input should be from source qualifier transformation.

source---->sq--->seq--->
joiner---->trg
source---->sq---->

we cant create mapping like this because seq does't allows port to create and accept from other tr.

src--->sq--->
joiner--->trg
seq--->
we cant create like this. joiner inputs should be from source qualifier.

how to create user defined function (udf) in informatica

1315

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2038

---

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

1130

---

What is the difference between a repository server and a powerhouse?

1515

---

Is there any target staging area in informatica not staging area

2581

---

Explain the tuning lookup transformation - informatica

999

---

What is the format of informatica objects in a repository?

1022

---

Why do we need informatica?

1002

---

How are the sources and targets definitions imported in informatica designer?

1111

---

What is dimensional table? Explain the different dimensions.

1175

---

What is olap (on-line analytical processing?

1074

---

Enlist the advantages of informatica.

1071

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2012

---

What are the tasks that source qualifier perform?

1108

---

What is the difference between router and filter?

1277

---