DSXchange

HI I am yet to check with that code as I dont have source data
thanks for the help

meet_raghu wrote:you may use
First_Name=Field(fullname,' ', 1)
Last_Name=Field(fullname,' ', 2)

in transformer.

HI I am yet to check with that code as I dont have source data thanks for the help Lets say input column is A use the following in your derivation or stage variable Set first Name To The following derivation: A[1,Index(A,' ',1)] Set Last Name to the following Derivation: A[Index(A,' ',1)+1,Len(A)-In...

There is a column called fullname in the source having the name like "kenneth browne" where the string before the space is first name and after space is last name Now my question is, In the transformer I have two columns called first name and last name ie kenneth should be populated to fir...

Hi In the look-up u have to mention what if the condition fails and look-up fails by default it fails the job which in ur case aborting the job please have a check in that area thanks Suresh I have a simple job that uses a lookup stage to lookup a column from Database A into a similar column in Data...

Hi In the look-up u have to mention what if the condition fails and look-up fails by default it fails the job which in ur case aborting the job please have a check in that area thanks Suresh I have a simple job that uses a lookup stage to lookup a column from Database A into a similar column in Data...

hello all, faced with a new prob :( my requirement: SELECT A,B,C from aaa. For each row selected, three records are written to the output file. Each one is identical except for the first field in the record. the first field has to be XXX,YYY, ZZZ. my output file is going to look something like this...

Hi the source stage is oracle the target stage is file all the file have similar records which just vary in first column Now, U can use a copy stage to create as many copies as u want followed by a transformer in which u can hard core or use stage variable for the first column in each individual lin...

The stages I am using is seq file(source) transformer and oracle(target stage

ray.wurlod wrote:Also please advise what stage type you are using. The answer may be different depending on which it is. I assume, from your subject line, that it's the Orcle Enterprise stage. But please verify. ...

My source is file and target is oracle when I am usng the upsert method the records are getting populated in the target but when I am using the load method the job is getting aborted giving the following error Oracle_Enterprise_2,2: sh: line 1: sqlldr: command not found The call to sqlldr failed; th...

Hi Suresh Garu, My source is file and target is oracle when I am usng the upsert method the records are getting populated in the target but when I am using the load method the job is getting aborted giving the following error Oracle_Enterprise_2,2: sh: line 1: sqlldr: command not found The call to s...

Can we use a load option when loading data from file to table where the transformer in between is used to change the datatype I have a problem, like, Hi Suresh Garu, My source is file and target is oracle when I am usng the upsert method the records are getting populated in the target but when I am ...

Hi My source is file and target is oracle when I am usng the upsert method the records are getting populated in the target but when I am using the load method the job is getting aborted giving the following error Oracle_Enterprise_2,2: sh: line 1: sqlldr: command not found The call to sqlldr failed;...

Hi I guess In the transformer, left pane bottom put the datatype of the source and in the right pane bottom put the datatype of the target Now in the drag and drop canvas right click on the derivation part, u can see the type conversion functions and which ever conversion u want u can go ahead this ...

Hi I guess In the transformer, left pane bottom put the datatype of the source and in the right pane bottom put the datatype of the target Now in the drag and drop canvas right click on the derivation part, u can see the type conversion functions and which ever conversion u want u can go ahead this ...

Hi I guess In the transformer, left pane bottom put the datatype of the source and in the right pane bottom put the datatype of the target Now in the drag and drop canvas right click on the derivation part, u can see the type conversion functions and which ever conversion u want u can go ahead this ...