Pig cross join and replace
<p>I have two files. One file having the data as below</p>

<pre><code>Ram,C,Bnglr
Shyam,A,Kolkata
</code></pre>

<p>The another file is having a reference</p>

<pre><code>C,Calicut
A,Ahmedabad
</code></pre>

<p>Now using pig, I want to search and replace the data in the original file to create a new file ,so that I can create a new file using these two files. </p>

<pre><code>Ram,Class,Bnglr
Shyam,Ahmedabad,Kolkata
</code></pre>

<p>Is it possible in pig. I know how to do that in MR but want to try out in pig.</p>