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




Answers were Sorted based on User's Feedback



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

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

Is This Answer Correct ?    14 Yes 4 No

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

Answer / natasha

use a merge stage.

Is This Answer Correct ?    12 Yes 5 No

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

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

Is This Answer Correct ?    8 Yes 2 No




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

Answer / gourav

using merge, join or lookup stage.

Is This Answer Correct ?    8 Yes 4 No

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

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

Is This Answer Correct ?    4 Yes 2 No

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

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.

Is This Answer Correct ?    3 Yes 1 No

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

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

Is This Answer Correct ?    2 Yes 1 No

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

Answer / sag

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


sag

Is This Answer Correct ?    2 Yes 1 No

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

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

Is This Answer Correct ?    2 Yes 2 No

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

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.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer



More Data Stage Interview Questions

What modeling tool do you use?

6 Answers   HP,


how CAN we remove duplicates in dataset?

2 Answers   IBM,


i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?

2 Answers   Wipro,


My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,


Can aggregator and transformer stages use to sort the data? How ?

2 Answers  






Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?

7 Answers   IBM,


Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.

7 Answers  


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

0 Answers   IBM,


what is operator combinality in datastage?

1 Answers   TCS,


i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

0 Answers  


1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,


HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com

5 Answers   FIS,






Categories