Page 1 of 1
Compare stage output subrecords in ()...
Posted: Thu Jul 22, 2010 10:46 pm
by allavivek
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
Posted: Thu Jul 22, 2010 11:09 pm
by ray.wurlod
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.
Posted: Thu Jul 22, 2010 11:11 pm
by allavivek
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...
Posted: Thu Jul 22, 2010 11:21 pm
by allavivek
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...
Posted: Thu Jul 22, 2010 11:56 pm
by ray.wurlod
I guess you need a Promote Subrecord stage in there.
Posted: Fri Jul 23, 2010 10:22 am
by allavivek
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...
Posted: Fri Jul 23, 2010 3:57 pm
by ray.wurlod
Two Promote Subrecord stages, then.
Posted: Fri Jul 23, 2010 3:59 pm
by allavivek
ray.wurlod wrote:Two Promote Subrecord stages, then. ...
So then what format should be the output columns defined for my output data....
Posted: Fri Jul 23, 2010 4:02 pm
by ray.wurlod
Enable RCP and let DataStage decide that, then inspect the output and see how you want to label things.