DSXchange

Hi Nag,

You told that exported the complete project from one environment.
i.e you exported with job executable's?

if it's yes In that case try with re-import the project with job design's only .


Best Regards,
Rajesh

Hi Pradeep, u didnt mentioned source if it's database we can generate sequence no at source stage using user defined query: I have requirement to generate the sequence number for the duplicate enteries. select ID,RANK() OVER (PARTITION BY ID ORDER BY ID) Seq_number from schemaname.tabname OR using s...

Hi, I have requirment to read the excel file(.xlsx) with multiple sheets contain using datastage job.i dnt want to convert into .csv format and read though seq file ,instead i want to read as .xlsx. Please which stage will use for this requirement and what are the properties need to be set. I saw so...

hi,
record length is not impact and it's impact onhuge amount of data coming from source.
sort stage is restrict memory usage property.by default it's 20mb.so can incraese the cache of restrict memory usage with in the sort stage.

hi, both ABC,DEF tables are same database or different.if same DB you can prefer user defined query. If both tables are from different db you can go through px design and you mentioned huge amount of data. so you can better design with join stage using leftouter. abc--->sort---->join(leftouter)---->...

Hi, use substring function in transformer to get this output for current requirement. seq----->txr----->seq2 in transformer u will craete two columns Char_col and Num_col use substring fun in derivation of corresponding column inlink.column(1,1):inlink.column(3,1):inlink.column(5,1)-->Char_col inlin...

i have 1 record in source but i want 10 records in target in DataStage. how get
data.

tell me if you know any logic or what is stage for using for this job?