Answer / vijay

Hi Kiran ,

We can populate the sources metadata to target without
using funnel stage using "Seqential File" Stage.

let me explain

In Sequential file we have a property called "File" so first
u give the file name and load the data.

Next time in the same sequential file right side we have a
property "File" just click on that so it will ask another
file name just give other file name ...do not load the data
, in the same you can give how many files u have.

Finally u ran the job Automatically the data will be appended.

Thks

Answer / natasha

use a merge stage.

Answer / sagar

better use join stage kiran,bcause join stage accepts
toretrive the records from different stages,and also join
accepts many inputs and one output link.so dis stage can
satisfies ur condition.and also ihave to say merge,lookup
accepts rejects u need one target so join will satisfies....


ur's
sagar

Answer / gourav

using merge, join or lookup stage.

Answer / venugopal

Hi Kiran,

We can populate the sources metadata to target without
using funnel stage using "Seqential File" Stage.

let me explain

In the source file path uu can mention process date and
file name with *.txt extension
For Ex:
#SRC_DATA_DIR#/JD/incoming/intermediate/*#PROC_DT#_SHIPMENT*
.txt

Above path PROC_DT is process date and SHIPMENT is file
name

Now the data can be retrieved from multiple files and
populated into a single file.

Hopes this will help you Kiran.

Any Doubts cal on 09767117168

Answer / subhash

1. Parameterise the File name and pass the diff file names
at run time, in the target we can put write mode 'append'

2. We can add multiple 'File' properties in the seq file
stage and give them diff file names and run it.

3. If all files are in same directory, then
File: DirectoryName/*#Date#.txt
and run the job.

Answer / kiran

hai sagar,gourav and natasha..,Ur answer is correct but my
quetion is wrong .
my reqment is, i am having multiple sources(flatfies)
and sources metadata same and poulated to target without
using funnel stage

Answer / sag

so kiran,iam not hving idea viewers plz respond kiran's
requirement


sag

Answer / sesadri

In sequential Stage keep file method as File Pattern, and provide the file name as File_Name_*.csv and file should have similar naming convention.

Answer / 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...

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

1 Answers   IBM,

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

0 Answers   IBM,

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

Distinguish between informatica & datastage. Which one would you choose and why?

0 Answers  

Define Data Stage?

0 Answers  

what is the use of DSattchJob?DetachJob? where can we find it?

0 Answers   IBM,

What are the processing stages?

0 Answers  

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

2 Answers   IBM,

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

10 Answers   Polaris,

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

0 Answers   IBM,

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

How many types of views are there in a datastage director?

0 Answers