DSXchange

hi, i know if sequencer failed ofter loading some records but how to run a job if job failed ofter loading some records Ex:i have 1000 records in source job is aborted ofter loading 600 records how to load remaining 400 records i faced this one in one interview normally if job is aborted i didn't fi...

Is there any relation b/w dataset, configuration file or seq file and configuration file

can any one please how to implement scd2 with stages are required and with sample data. with either 7.5 or 8.0 versions actually i my project we are not maintaining any SCD's



i need lo know about scd's

how to update data in dataset,

normally we r using write method is overwrite,

instated of overwrite how to use update.
i want update data in my dataset

Hi,

take sort stage set properties like allow duplicates=T,
creatate key change column=T,

in filter u can write conditions like
whre creatate keychange cloumn=0---->to capture duplicate records

where creatate keychange cloumn=1---->to capture unique records

hi ,

i heard about pre partitions techniques in datastage can any one share information on this.

What is the problem you are facing ? Is it giving incorrect values or you need to know how to do the coding ? If you are using a database as our target, you can create an user-defined SQL to cal ... HERE SOURCE IS FLAT FILE TARGET IS INFORMIX SOURCE FIELD IN SQUARE_FEET IN TARGET I NEED IN SQUARE_M...

ray.wurlod wrote:In a server job or in a BASIC Transformer stage you can use the SDK Transform MeasureAreaSqFeetToSqMeters.

Detail of its transform definition:

Code: Select all

(%SqFeet% * .09290)

Otherwise ...

I NEED IN PARALLEL JOBS

how to convert Square_feet into Square_meter in my source file one column in square_feet i need to convert into Square_meter when loading data into the target. i know 1 square feet=0.0929 square meter i taught by using transformer 0.0929*square_feet column=square_meter this is possible or any other ...

Hi all, Can anyone tell me what are files created when we create a Dataset and their locations? And i searched in this forum then i came to know descriptor file and control file will be created for each dataset. Whichfile will be created in Resource disk path? And where will be actual data stored? ...

nagarjuna wrote:duplicates stage , sort stage , transformer stage ......

with using sequential file only

not using sort,remove duplicate,T/F

hi,

how to handle duplicate records in sequential file

either deleting or sending to rej link

my i/p like this
column
001
102
1300
00102

required o/p like this
column
1
102
13
102

how to achive this one

hi,

source wiil be like this:
co1,col2,col3
100,a,hyd
101,b,hyd
102,c,blore

if i use remove duplicate o/p will be like this:100,a,hyd
102,c,blore
but required o/p will be like this:102,c,blore

can any one help.......

hi,

recntly i got the job in DataStage,

i know some documentation nemes like
1.mapping doc, 2.Technical doc,3.test csae doc,4.functional doc

i know abe all above doc Except functional doc
can any one give me brier introduction about functional doc