DSXchange

Hi Experts, How to resolve this warning since it is generating for each record: APT_CombinedOperatorController(0),0: Invalid character(s) ([xFF0C]) found converting Unicode string (code point(s): Manual payment #5100001146[xFF0C]61 ) to codepage ISO-8859-1, substituting. Is this warning is due to th...

ray.wurlod wrote:It's completely different in version 8, which is why I told you to use the Web Console for Information Server. ...

Thanks for the reply Ray,

since i am unable found the option in Ver8.0.1 please let where exactly it is found.

Thanks

ray.wurlod wrote:It's completely different in version 8, which is why I told you to use the Web Console for Information Server. ...

Thanks for the reply Ray,

since i am unable found the option in Ver8.0.1 please let where exactly it is found.

Thanks

Record the identity of the owner, which is revealed when the "job locked" message box is displayed. Using the Web Console for Information Server choose Session Management and disconnect that particul ... Hi Ray, Can you be some what how to do these or You mean to say in Cleanup resources,...

Hi Experts,

How to release the job from read only mode(itseems to be job will be in read only when datastage job not properly closed).I am using common ID.

Cartesian product. Inner join or left outer join. Right outer join. UNION ALL. Difference (sometimes called "minus"). ... Thanks Ray, accordling to your solution for the example,I got wat i have perform right outer join.but the output(ex:2500 as below) and it should be left outer join can...

Cartesian product. Inner join or left outer join. Right outer join. UNION ALL. Difference (sometimes called "minus"). ... Thanks Ray, accordling to your solution for the example,I got wat i have perform right outer join.but the output(ex:2500 as below) and it should be left outer join can...

ray.wurlod wrote:Which part of "examples of rows" wasn't clear? ...

Table A2 record has to populate with existing table A1 to target table how do these.

Thanks,

So what is "the desired result"? Give a brief example of rows from inputs and expected output. ... Suppose there are two tables(A1,A2) with out common column,I want to fetch one column From A2 and join two tables with existing column of the A1 and map all the column to target.and if suppo...

ray.wurlod wrote:Not possible. Technique 1 was specifically "add a dummy column". Use a column generator stage upstream on each input link to the Join stage. ...

Thanks for the reply Ray

ya i have tried that but still it is leading the cartesian product .

ray.wurlod wrote:Technique 1.

Technique 2 is a UNION ALL, not a JOIN. ...

thanks for the reply Ray,

So how to perform join without common column.Please let me know how to acheieve that.

Please let me know how to join to two tables/files with out common column. Approachs made: Techinque1:adding a dummy column on both side and giving column extended properties algorithm=cycle and value=1 and increment=0 than it wil lead to cartesion product but we wil not be getting the required resu...

Sometimes it is available from a right-click on the canvas, but no shortcut from there. There is only the accelerator Alt-V (depending on language) when you are on the correct page in the editor. Thanks for the reply deanwalker I came to know that ctrl-V is used to view data but it was not working ...

Hi Experts,

Is there any short cut for viewing the data in OCI,DB,FIle stages other than going and clicking view data,While reading or writing to it like(For eg:In msword for copy-->CTRL+C)

Thanks for reply.

[quote="shahidbakshi"]Hi All, need some help rgd data stage PX. If S1 and S9 are two data sets, and we want to join those on the follwoing conidtion and need some output. S1.OI_TEXT_REFER = S9.TEXTID OR S1.LI_TEXT_ID = S9.TEXTID OR S1.PO_SHIP_TEXT_ID = S9.TEXTID OR S1.PO_TEXT_ID = S9.TEXTI...