DSXchange

Hi Friends, I designed a job like Job 1)DB2Stage----->TransformerStage------>Sequential stage...working fine Above job target sequential file I'm using as source stage Job 2) Sequential stage---->TransformerStage------>DB2stage While reading the data I'm getting below error: Sequential_File_29,0: Fi...

Hello Friends.

I have 100000(1 Laks)data in my source.
I need ti design i job like first I need load 50000 Records to target in 1st Run.
Similarly 2nd Run I need to load only remaining 50000 records.
Could you please help me this issue.


Thanks
-----------
Vijay.

Hello Friends can please halp me below quetion


1)Is there any hashed file in Parallel system ?
2)If its there tell about uses of Hashed file?

3)is hashed file improves improves the performance when we use with lookup.How it will improves

I'm not c++ resource Actually I'm a DataStage resource I got situation to write routine in C++ for this Encryption& Decryption.My team doen't provide any algorithm to follow and idon't have bit shifting experience. which algorithm following is not a issue.I need to write routine please can you h...

Hello Guy,
I have issue in datastage. I have source with 1000 records, I run the job 500 Records loaded into target then my Job is Aborted at 500. I want to reload the records from 501 onwards.

can you please help me out?

Hello Guys, I have source with 2 columns,One is Account_No,second one is Account_Hold_Name.My requirement is need to data scrubbing/scrambling data of first one(Account_No) its not exactly Encrtpt and Decrypt.its data scrubbing/scrambling. Example: Account_No:ABC123456 We need to scrambling. the dat...

Hi friends, I have .csv file as input(source),Belove i showed design of the job Seq-------->Tranformer--------->dataset I can able view the viewdata of Seq file and job successfully executed I'm getting waring like 1)SF_Lead_Daily_Inputfile,0: Import consumed only 303bytes of the record's 304 bytes ...

i have 6 SQL queries on that 3 has to fire regular months remaining 3 has to fire only on jan month by using variable stage i have to solve this
anybody help me out

i have three dataset sources while doing funnel im getting this type of error
i checked all me metedata was same plz help me some one



DS_Lead: When checking operator: The modify operator has a binding for the non-existent output field "Country__c"

Sequential_File_10,0: Missing record delimiter "
", saw EOF instead

i have 3 datasets i need to funnel them all column are same but size are changing for few column

my source is mainframes im getting the data data type is char but i need to load it in Double data type i used StringToDecimal convertion as per design doc but im getting expected output with warnings plz help out from this problem Xfmr_ICLIC_Load,3: Conversion error calling conversion routine decim...