Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

With out using Funnel Stage, how to populate the data from
different sources to single target

Answer Posted / bharath

Hi kiran,

in one same job you create as follows,

seq1------>tseq1

seq2------>tseq2

step1:load first source into tseq1 as file name tgt.txt

step2:load second source into tseq2 as file name
tgt.txt(ensure file name first file name only)

step3:Give file upload mode=Append


run for one time you will get...

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to implement scd2 in datastage 7.5 with lookup stage

5549


What are the stages in datastage?

1028


How do u convert the columns to rows in datastage?

1140


how to write server Routine coding?

2061


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1684


how to delete one row in target dataset

3062


what is repositery?

1768


What is process model?

1919


Different ways a project can be moved to production ?...example ….export-import and Version control.

2387


What is "fatal error/rdbms code 3996" error?

1190


Describe the architecture of datastage?

950


How to reverse the string using SQL?

1425


How a routine is called in datastage job?

1042


What are the different options associated with dsjob command?

1370


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

752