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

What is difference between server jobs & parallel jobs?

625


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3273


What are the steps needed to create a simple basic datastage job?

667


What are the enhancements made in datastage 7.5 compare with 7.0?

713


How you Implemented SCD Type 1 & Type 2 in your project?

3699






Can you explain tagbatch restructure operator?

707


What are iconv and oconv?

779


What are the main differences you have observed between 7.x and 8.x version of datastage?

626


To see hidden files in LINIX?

948


Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1671


what is the use of materialized view?

967


explain about citrix scheduling tool in datastage

1812


If you want to use a same piece of code in different jobs, how will you achieve this?

800


how can we create rank using datastage?what is the meaning of rank?

8193


How many Key we can define in remove duplicate stage?

824