DSXchange

Hi, We have file with Chine characters and other special characters, Profile stage is not able to profile that file and it's throwing error like "contact technical suport error 98" like that. We tried giving data type as NVarachar, it's reading that kid of Data types. Any one who is having...

Thanks Guru, In the same manner we may have more then 10 input fields and like that we need to split single record into 10 output records, The main thing we need to split record, that's all....Can any body tell me how to implement this splitting record scenario in data stage Thanks in Advance

Just sample I given 4 columns like that i had so many, so useing more sequential file stages is problem here, Can u tell me what is another way,
The total thing is Just we need to split record into multiple records to target.

Thanks in Advance

Hi, My requiremnt is , I have 1 record in source file and I need to write that to target as 2 records , that means that single record needs to be split into 2 records Example: Input is ******* Single record Col1 col2 col3 col4 a 1 3 4 Output: ****** 2 records a 1 3 a 4 Like this, Pls help me how to ...

Hi,

How to read PIPE delimited flatfile in PS, In documents also given only for "Comma,TAB,FIXED or Character" only, these 4 options only mentioned in DOCs. is there any other option to read PIPE delimited flat files.

Pls share your experience...

Thanks in advance.

HI, In profile stage client while loading database metadata we should provide one database name right, how to delete that database in PS client it self, Scenario is Like......., I am trying to read data from flat files for I got problem to read 'PIPE(|)' delimited files so, I tried in somany ways th...

Hi While trying to Generate Tragte data specification OR datastage job specification through Profile stage, It's throuning below error 3/27 16:12:08: New Log - 3/27 16:12:08 3/27 16:12:08: MessageSwitchConnect String: HostIPAddress = HostName = 10.185.51.203 HostPort = 3070 ApplicationID = 2 HostUse...

yes.....I tried that also and I deleted that code and exported again still it's giving same problem

yes.....I did that but there is no exact solution, just some discussions are happened earlier.......that's why I posted if have any idea pls share with me

Thanks in Advance

Hi,

I am doing hash partitioning in sortstage and it is gioiving below problem.

APT_CombinedOperatorController(2),0: sh: dbx: not found

Hi novneet, Earlier I am doing sorting, once I read data next stage doing sorting, So after all lookup check's and all doing some caluculation so that as per pallel partitioning and all output is not coming properly. So, now i am doing sorting just before the caluculation that means after all lokup ...

yes there are warnings but not for that stage, some other lookup and all giving warnings, there are no warnings for sort and sequential file stage, but it's not sorting data properly,
share your ideas with me

Hi, I am using sort stage in my parallel job once read data by using sequential file next i am using sort stage, it's not sorting as i given and send ing same input records to output so that ia m facing problem and caluculation is not happening in next transformer stage, so pls any one has experienc...

Thanks Andrew just subseq is triggering that first job as per order of design and that job running ever but it's not giving any log information just it's giving 1 line of log in director even it's not giving that starting of job info also. we are not getting anything more then that but status is run...

master seq is triggering that subseq and as per design that subseq should trigger first one parallel job, but it's not doing that allways it's in running state that job is same as others it's reading data from oracle loading into dataset, the main problem is calling any jobs through that subseq it's...