Compare stage output subrecords in ()...

allavivek · Post by **allavivek** » Thu Jul 22, 2010 10:46 pm

Hi All,

Iam using compare stage and for output i enabled RCP and defined 3 cols..
diff(tinyint)
first(unknown)
second(unknown)

Iam getting proper output but problem is iam getting like below format..

Code: Select all

diff   first              second
-1   (1,aaa,bbb)    (3,aaa,bbb)

Iam getting subrecords in braces..Is this correct format or do i need to change any options...

Thank you

Code: Select all

ray.wurlod · Post by **ray.wurlod** » Thu Jul 22, 2010 11:09 pm

This is the correct format. The braces are added by the data browser; they are not actually part of the data, but are indicated by the metadata (record schema) in which subrecord is indicated.

allavivek · Post by **allavivek** » Thu Jul 22, 2010 11:11 pm

ray.wurlod wrote:This is the correct format. The braces are added by the data browser; they are not actually part of the data, but are indicated by the metadata (record schema) in which subrecord is indicated. ...

Thank you ray...

allavivek · Post by **allavivek** » Thu Jul 22, 2010 11:21 pm

But Ray is it possible to copy data from this format to other target...

when iam trying to copy data from dataset to seq file...its giving following error..

input first is not value field....

Thanks...

ray.wurlod · Post by **ray.wurlod** » Thu Jul 22, 2010 11:56 pm

I guess you need a Promote Subrecord stage in there.

allavivek · Post by **allavivek** » Fri Jul 23, 2010 10:22 am

ray.wurlod wrote:I guess you need a Promote Subrecord stage in there. ...

Hi ,

I was trying to use promote subrecord stage but in properties iam able to specify only one parent column...but iam two parent columns...

Any ideas...

ray.wurlod · Post by **ray.wurlod** » Fri Jul 23, 2010 3:57 pm

Two Promote Subrecord stages, then.

allavivek · Post by **allavivek** » Fri Jul 23, 2010 3:59 pm

ray.wurlod wrote:Two Promote Subrecord stages, then. ...

So then what format should be the output columns defined for my output data....

ray.wurlod · Post by **ray.wurlod** » Fri Jul 23, 2010 4:02 pm

Enable RCP and let DataStage decide that, then inspect the output and see how you want to label things.