DSXchange

I have a pipe delimited file that I need to pivot to multiple columns: e.g. key| col1 | col2| col3 | col4| col5 1 |A |B | | | 2 |C | | | | I want the result to be: key | col 1 | A 1 | B 2 | C But I'm getting the following from my pivot stage: key | col 1 | A 1 | B 1 | 1 | 1 | 2 | C 2 | 2 | 2 | 2 | I...

Thanks Tom for your responses.

It still failed when I have the model properties/model names in the Physical model.

And it works if I saved to Erwin 4, export the XML , and import into metastage. Can I safely conclude that I can't use Erwin7 with Metastage for this release?

Karine.

Tom,

I'm on Metastage 7.5.2r3 and I tried to import a erwin 7 xml into Metastage and it failed with the following error:
ERWIN40_W_MODEL:Cannot find tag 'Model' . Invalid Erwin 4.0 XML file.

Do I need to upgrade to 7.5.2r8 ? Do I also need the latest version of MetaBroker?


Karine

Hi all, I'm new to MetaStage. I would like to know what's the purpose of ConnectedTo relations. I have imported my Erwin Logical/Physical Data model into Metastage (xml and then Erwin 4 broker) and I want to connect the entity e.g. Account, with the table ACCT, in MetaStage explorer. It doesn't allo...

I have remove "Quote" property but still got the same warning.
Any other suggestions? This is really bugging me.

Sorry for the confusion and the wrong post. My OS is windows. I've following Ray's suggestion : Record Level - Final delimiter = none Record delimiter string = \r\n (dos format) and still the warning said Sequential_File_0,0: Missing Delimiter "\r\n", saw EOF instead Sequential_File_0,0: I...

I'm reading a sequential file with the following format col1 char(3) col2 char(5) col3 char(8 ) and below are my sample data: 1112222233333333 4445555566666666 The sequential file stage has this definition: Record Level - final delimiter = none Field Level - Delimiter = none Quote = none This are th...

I'm reading a sequential file with the following format col1 char(3) col2 char(5) col3 char(8 ) and below are my sample data: 1112222233333333 4445555566666666 The sequential file stage has this definition: Record Level - final delimiter = none Field Level - Delimiter = none Quote = none This are th...

Thanks Ray, The following are my settings:

Record Level Field Delimiter = end, Record delimiter (not specified)
Field Defaults - Delimiter=none, Quote=none

I'm testing implicit conversion in sequential file stage. The seq file has single column with 7 rows: 1 aaa 3333 4A 4B8 345.7 2006-10-20 My output definition for col1 is Integer as I want any non integer data to be sent to the reject link. However when I view the data in data browser, I'm getting th...

No.they are all .txt extension.

Hi main_program: Data Set, file set, or file "SQ_Src_Data:Lnk_Src.v":Non-pipe (or non-virtual data set) with .v in its name Job tst1 failed validation. My job compiled fine, but failed validation with the above error. Can somebody please tell me what the issue is? Thanks in advance. Karine

When I tried to open an existing job, a message appeared with "Job job_name is being accessed by another user" 1) How can I find out who is accessed this job? 2) If I want to force 'Unlock' this job - how can I do so? I have been asking my co-workers and nobody own up accessing the job and...

I'm also want to "deconstruct" the varbinary field into its columns, but when I tried to link the rejected seq file or dataset (from a reject link) to a transformer stage, I'm getting the error message - The source stage does not support non-reject output links whilst it has input links. A...

Hi Kumar,
I have a similar requirement where I need to identify the rejected rows with its column values so that the data steward can analyze the error. Can you please explain how I can convert varbinary into varchar or its columns ?

Karine