Answer Detail: RE: can u join flat file and database in datastage?how?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Print |

Question: how can u implement slowly changed dimensions in datastage? explain?

2) can u join flat file and database in datastage?how?

November 11, 2005 01:28:59	#2
Sridhar Vuligonda	SQL Server Expert Member Since: November 2005 Total Comments: 4
RE: can u join flat file and database in datastage?how?
Yes, we can do it in an indirect way. First create a job which can populate the data from database into a Sequencial file and name it as Seq_First1. Take the flat file which you are having and use a Merge Stage to join the two files. You have various join types in Merge Stage like Pure Inner Join, Left Outer Join, Right Outer Join etc., You can use any one of these which suits your requirements.