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.

What is rank transform?

997

---

how we can load rejected record's at run time?(not through bad files)

2379

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7065

---

Define joiner transformation?

1049

---

Tell me about Propagate functions in informatica

922

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1154

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1267

---

Explain dynamic target flat file name generation in informatica

1055

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1127

---

What is a grid in Informatica?

1070

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

What is confirmed fact in dataware housing?

6968

---

Explain why we use partitioning the session in informatica?

1093

---

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

1107

---

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

1081

---