DSXchange

I have a requirement to generate the same set of records based on codes & input data. my input data looks like John|101|M|23 Kathy|102|F|40 Jean|103|M|23 Pauk|104|M|55 I have standard codes US,GB,MX,CA and the output should be John|101|M|23|US John|101|M|23|GB John|101|M|23|MX John|101|M|23|CA K...

Yes added 'dot' and Time(15,6)

Still the data is like '10:26:38.000000' in Table

Convserion :- StringToTime(InputCol,"%hh:%nn:%ss")

My input is '10:26:38.123456', but how to get micro seconds ?

Hi I have a problem while i convert to string to Time. my source is Flat file(fixed width) and need to load data into table(teradata) The data for Time column from File is like 10:21:15 09:06:58 12:45:06 etc., I am generating some random numbers like 000001,123466,001523, etc., Now i need to append ...

Hi I am generating a flat file in fixed-width and i need this file in UTF-8 format. I changes NLS map in sequential stage and also in job properties to UTF-8. but when i check the file in unix box, it was showing as us-ascii . i used below command for file format check in unix File -bi <FF1> output:...

Yes this file will overwrite on every run and i have put the reject link also.

But still i can see the same issue that after a gap of 2-3 hours, the record is not imported.

Hi Chullet, This will work if i ran the job 4-5 times continuously.. If the job is compiled, then the record is not imported, though there will be 1 record and i am able to see the record in file in unix directory. "Dt_Counter,0: Import complete; 0 records imported successfully, 0 rejected"

Hi I am facing a strange issue with sequential file stage. I have a file with 2 columns with only one records. Date: varchar(10) seqno:char(3). I am using the above file as a lookup reference. ISSUE:- When ever i compile the job or run after 2- 3 hrs later, the data from file is not importing and it...

The issue is i am not able to export the jobs (.dsx) it was throughing error like , the job is being is used by another user. and there were no users currently. so i want to clear the lock or cleanup resource from Director or UNIX. @Arun, i even tried in administrator, can you let me know how to pro...

HI I tried to Unlock the jobs and i used some standard methods from Director and Unix and i am not successful. I don't have Admin privilages as i am a developer. In Director i had done cleanup resource and logout the processes, based on PID. Also in UNIX box i had killed the process by PID, but it w...

Suppose if u had two where conditions, 1st where condition:- Dept no =10 The condition met records will pass into Target1 2nd Where Condition :- Dept no in (10,20,30,40) If you use 'output row only once' , Then the record will not pass the second where condition and it will not go to Target2. if you...

Hi Guys, It will be helpful if anyone provide partitioning types for all stages like Stage ---------- Partition ---------- Alternate Partition ----------------------------------------------------------------- RemDup ------- Hash ----------- Auto Join ---------- Hash ---------- Auto ans so on.... You...

Let us assume that your primary Data having 1000 records and make a your target as a reference and by filtering the data based on any dummy value, then only records which are not already inserted will be loaded into target. your job desing should be like this : Reference(Target) | | Join------>Filte...

Hi

Can we Connect Higher version Datastage Client(8.7) to Lower Version DS server(7.5.x).

If yes, what are the compatiblity issues if we import the dsx and compile/run the jobs.

I mean what are the scenarios that my job is getting Hanged,
i asked my Network team and Unix team and they said there is no critical issues seen while thie job is running.

and its get hanged after importing 95% of data from xml files

Hi , My DS job gets frequently hanged and sometimes it run very slow rather than expected time. The job is reading 8 xml files and loading data in Teradata Table. --8 xml files---Funnel--- Tfm--- TD table--- and it is using 8 node config file and the data is approximately 14940000 records and it tak...