DSXchange

Hi,

my question is i am having source coming in form of flat files ,but i want names code and usuage code from the table,so can i put a constriant in transformer and use it to filter some required records.
Thanks
sunitha

Hi,

I got a sequential file from col 1 col2 should be sent to the taregt i have 100 columns in the source ,how can we move these records.
Thnaks
sunitha

Hi,
when do we go for DATAESET STAGE and when do we go for FILESET STAGE,AND WHEN DO WE GO FOR SEQUENTIAL STAGE,i know what it is meant but in realtime how each is used.CAN ANYONE EXPLAIN IN DETAIL,THEY R VERY CONFUSING.
THANKS
SUNITHA

Hi, I am getting data in form of flat files , from as/400 where data is in form of flat files .This data has to be loded again into flat files in target ,but in between th source flat files and target flatfiles we have to perform transformation ,so how can we exactly apply the transformation ,if the...

Hi,
then how can we query flat files.
Thanks
Sunitha

Hi,

Query here means take wanted records do a transformation.
Thanks
sunitha

Hi,

Actuallu i am using as/400 coming in the form of flat files,so how could the source be taken i mean which stage or databse to do query in the flat files.
Thanhs
sunitha

Hi,

I want some idea regarding dataset and fileset,i know very well in data set the data is stored in internal storage format,and in fileset human readble format,but can we do query on the file set or datset if we take as source.

Thnaks
Sunitha

Hi,

I am using flat files as source ,can i do query on the flat files.
Thanks
Sunitha

HI, The first and foremost thing ,I did was we got data in the form of flat files, I have 2 flat files say f1 and f2 ,read f1 names file and check if name stem (first 4 characters of name )is present in f2 names stem file flat file.I f found update sequence number else add new name stem with sequenc...

HI, I have 2 flat files say read f1 and f2 ,read f1 names file and check if name stem (first 4 characters of name )is present in f2 names stem file flat file.I f found update sequence number else add new name stem with sequence number, increment sequence number or all records in f2 by 1. HOW CAN I I...

Hi,

My data is in as/400 In As/400, we had to run multiple queries that is done in by using sequeals but now we are migrating that data is in form of flat files ,now in datstage server edition so how can we run those multipe queries .,and extract a single column data.
Thanks
sunitha

HI all, I am coding jobs in server edition,i want to know clearly the concept of resuability ,because i should impement and show resuability in my jobs.i know that clearly we can do it by container and we have local and server shared container also ,i don't know how to implement ,can anyone guide me...

Hi, I need help in serting the records into taget Oracle table. oracle_stage-transf-lkp-lkp-oracle target ' ' ref table ' ref table Warning1:APT_CombinedOperatorController(1),3: Conversion error calling conversion routine timestamp_from_string data may have been lost. Warning2:Lookup: Input dataset ...

Hi All,

Can anyone give me the difference of head node and compute node.

Thanks
Sunitha