Answer / srinivas

Joiner is to join two different sources .If u use Update
strategy T.F and trying to use DD_delete&DD_reject option
the some of the data will get deleted and u can't see the
at joiner output.
So we can't go for this .

Answer / 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 kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

0 Answers   TCS,

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

---

How to handle decimal places while importing a flatfile into informatica?

0 Answers  

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

0 Answers  

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010

2 Answers   Accenture,

---

tell me the push down optimization

2 Answers   Wipro,

---

checkout and checkin in informatica 8.6

3 Answers   TCS,

---

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

---