Answer / sravanthi

using joiner tranformation to add two diff structure of flat files...

Answer / pradosh

if the flat files has diff stracture then
sd-->sq-->exp>
...>join-->tgt
sd1-->sq1-->exp1>

that means take flat file source then take 2 exp transformation in which u take variabl ports i.e a=1 and exp1 is b=1 then based on condition u take a joined trans and connect to target.

join takes diferent sources

Answer / vijay

you have two flat-files with u.
prepare two source instances with the structure you have as
oracle relational tables. after that change them to
flatfiles in the source instances.
then connect to the target's that u already prepared by
simple-pass mapping. now you have two relational source
tables with u,then join the tables using joiner.
--------------------------------------------------
how to join one relational and one flat file?
same as above convert the flatfile to relational table
through simple-pass mapping. now join two relational tables
using joiner in the same mapping itself.

Answer / mehul thakur

Hi sravanti
Could U please explain how to join ?

how to get the first row without using rank t/r?

7 Answers   iGate,

---

what is difference between COM & DCOM?

1 Answers   Satyam,

---

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

1 Answers  

---

What is Cognos script editor?

1 Answers   Cognizant,

---

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

---

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

---

What is option by which we can run all the sessions in a batch simultaneously?

1 Answers   Informatica,

---

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

---

What is lookup transformation?

1 Answers  

---

What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?

7 Answers  

---

can we use self join in informaitca?

3 Answers   IBM,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---