Answer Detail: RE: how to join the data of two tables which does not have common columns

GeekInterview.com > Tech FAQs > Informatica

Print |

Question: how to join the data of two tables which does not have common columns

Answer: how to join the data of two tables which do not have common column

i mean how to perform non equi join in informatica
Eg:just like getting data from emp and salgrade table of oracle where sal is between losal and hisal

thanks
venu

February 02, 2008 13:27:47	#10
tanya123	Member Since: February 2008 Total Comments: 3
RE: how to join the data of two tables which does not have common columns
Hi, The best way to join data from two tables which donot have common columns is first use a sequence generator transformation to generate the keys,then connect it to an expression transformation and then use a joiner transformation to join the tables.I think this will work... Any better answer will be appreciated... Regards Tanya

Back To Question