How Can we join one relational table and one flat file without having common key using joiner transoformation? Is it possible to join without common key to join using joiner transformation?

Questions by phanimv   answers by phanimv

Showing Answers 1 - 3 of 3 Answers

Venkat

  • Dec 19th, 2006
 

Hi

its possible to join one flatfile and one relational file without having common key.

Using the fullouter join you can join two files.

Regards

Venkat

manisha.sinha

  • Dec 29th, 2006
 

Create a dummy variable of the type number , default value 0 , in the SQ for Each of  the table and the flat file. Now join the two(table and flat file), with join condition on the dummy variable.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions