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 is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

---

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,

---

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

---

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

---

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

---

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

---

How will you combine 3 different sources with a single source?

3 Answers  

---

what is the incremental agrrigation?

2 Answers   Cap Gemini,

---

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

---