Answer / sagar

When you use sequential file as Source,at the time of
compilation it will convert to native format from
ASCII.where as,when you go for using datasets... conversion
is not required.Also, by default sequenctila files we be
processed in sequenc only.sequential files can accommodate
up to 2GB only.sequentila files does not support NULL
values....all the above can me overcome using dataset
stage....but selection is depeneds on the
requirement....suppose if you want to capture rejected
data....in that case you need to use sequential file or
fileset stage....

Answer / kiran

First we Know about Seq file and Dataset.

Seg file is used Extract the from flatfiles and load into
flatfiles and limit is 2GB

Dataset is a intermidiate stage and it has paralism when
load data into dataset and it inprove the performanece.

Answer / chiranjeevi.a

To over come the limitation of sequential file,espesially
sequential file: By default reads and writes sequentially
>memory limit is up to 2GB
>conversion is needed
>sourse stores the data out side of datastage
Data file:
>parallel process
>memory is unlimited
>No conversion is needed while reading the data(its
basically in native format).
>stores data inside the repositary

Answer / narayana

file set is nothing but collection of sequential files. if sourse database is greater than 2 GB than prefer to use file set.
Data set is internal stage in datastage.the extension of data set is .ds it never used to extract data from client location .it is used as intermediate stage between two tables.
Sequential : 1)it supports all formats like txt,csv,xls,etc.
2)it is used to extract data from flat files from client location.
Data set:1)it supports only .ds format
2)it will never extract data from flat files from client location.

Answer / pavan

datasets get processed in our local system rather than at
the server so performance gets enhanced in this case as
server is not loaded.

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

0 Answers   TCS,

on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers  

What is the precedence of stage variables,derivations, and constraints?

0 Answers  

Tell me the syntax of Configuration file?

1 Answers  

How do you get log info into a file?

1 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,

How do you start developing a datastage project?

0 Answers  

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

WHAT are unix quentios in datastage

2 Answers   TCS,

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers