DSXchange

Hi guys i have a problem in my job....... i am loading a excel sheet which has data like for example as given below in one of its column M NB без кофеин 100г-2кг NB Джезве 100г-2кг i am unable to view data in the exact same way. can any one tell me how do i get the exact data in my sequential file. ...

Wonderfull, thanks you so much

I have another issue which i had found. this time its about the delimeter. when i convert the excel sheet to CSV, i have data which contains comma. the CSV converts it in " quotes ". but i want to know if i had to change that delimiter for that CSV to say "tab" or "|" t...

Thanks

Hi I have to read an excel sheet into datastage, the excel sheet has various tabs and the data is extended in each tab. the data continues from one sheet to the other sheet without any break. if i had to convert the whole excel sheet to a CSV file then how can i do so :( .........pls i need some ass...

Can any one tell me the script to convert a text file which has no delimiters into a flat file with ^ or | or tab as deimiter. i need to get an idea of how the script will look like. please help thanks.

right thanks all.............shall speak about this later

Actually my issue is i have comma in the data and that might conflict with the csv file if i use comma as a delimiter. i want to use something else instead of comma as delimiter. :?: i am new to datastage and i never tried a batch script. could you please tell me what is it and how do i create it. :...

Hi again Well my apologies for slang language. :? my project manager wants me to take the data from excel files. as he does'nt have it other format. actually we are trying to do data migration from six legacy systems into one common system and we need to map all the legacy contents in excel format. ...

In an excel sheets we have different tabs, each tab will represent a new table. how can we read an excel sheet which has two tabs or more than two tabs in the in one excel file into a datastage job. Also apart from u said use tab as a delimiter can i also try ^ or | symbol as delimeters. what stage ...

Hi guys i want to know if we can directly load a excel sheet into the datastage job. if yes then what type of delimiter shall i use for the data. my excel data sheet has rows where ","(comma) is used frequently. i think i might have to take some other delimeter. is there any other precauti...

Thanks for the information.

ray.wurlod wrote:Yes, there are several strategies available.
Difference, Compare and Change Capture stages spring immediately to mind. ...

I have a functionality question concerning how DataStage can be used. We would like to determine if DataStage could be used to determine data changes over time. The idea is as we attempt to extract data, time will pass between extracts of the same data set. Would using DataStage to determine what ha...

Hi guys i need some information. If i had to install a new license of datastage. can any one tell me how many users can it support. like if i use just one license for three developers working on a project then Do you know the limitations of concurrent licenses? How does that impact your work activit...

Can anyone tell me why is datastage better for data migration. what are the advantages using datastage for migration. my project manager is asking me why is datastage a better tool than others for data migration. Can any one help me with this question. I am not realy sure what the answer. I shall tr...