DSXchange

Robert!

You got it! That worked just great for me!

It's unusual that that restriction does not apply to USNAME, USADDR, etc. but it does to USPREP.

Thanks!

Thanks guys!

but it's still a problem.

Ray,
It is when I right click on CopyOfUSPREP and attempt to rename it that this error message occurs. It does not let me rename it.

Stuart,
I need to use this CopyOfUSPREP in a job.

Any other ideas on how to rename it?

I have made a copy of the USPREP rule set because we want to modify it for a project (i.e. we don't want to make these changes to the original USPREP rule set). The new rule set is named by the copy process to "CopyOfUSPREP" I want to rename it to something more indicative of the project -...

Chulett, can you elaborate on "select a GUID via a Lookup or even as a source". How would I do that?

I have a situation where I need to insert a row to two different SQL Server tables and each of these rows must have the same GUID. Example: Insert to tbl 1: 1050715f-19e5-8f44-c1b8-4965c9a194d3 AAA BB CCCC Insert to tbl 2: 1050715f-19e5-8f44-c1b8-4965c9a194d3 XXXXXX YYYY ZZ I know how to generate a ...

I need some help tweaking a SQL query. I am getting an ORA-00937: not a single-group group function error. Normally I would fix this by adding a GROUP BY clause but that is not helping in this case. Is there a SQL quru out there that can solve this? To simplify the explanation of this SQL: the inten...

Brilliant, ArndW! Your suggestion worked perfectly!

I was unfamiliar with Message Handlers but after a quick bit of study I was able to solve this problem perfectly.

Thanks!

In Production we have a MANDATORY standard of allowing no more than 50 warning messages when a DataStage job runs. However, we are having a problem with many of our DataStage jobs that contain a Standardization stage. The warning message in Director that occurs (more than 50 times) is: Stdize_Prvdr_...

I am so sorry guys! That's what I get for submitting and then going back and changing the example. Here is the REAL input and expected output: ID CODE1 CODE2 CODE3 CODE4 1 A B 2 A C D 3 D B 4 B C And I want it to end up like this: ID CODE1 CODE2 CODE3 CODE4 1 B A 2 C A D 3 B D 4 C B Also, a further ...

Thanks for responding Eric! What I need is, for any record: if it has a C in it then that C must ultimately end up in the Code 1 column if it has a B in it then that B must ultimately end up in the Code 2 column if it has a A in it then that A must ultimately end up in the Code 3 column if it has a ...

I have discovered that if a job has too many warnings (50+??) then a signal is sent to interrupt the job. I had the same problem and once I reduced the number of error messages (null handling messages in my case) the problem went away.

[Ray,

Yes, I am. Sorry, I should have mentioned that. I know that I can use NAME_UNCERT if I was matching "SMITH JONES" to "SMITH" but how would I match "SMITH JONES" to "JONES"?

Thanks!

Glenn

Does anyone have a creative way to match last names in instances when a person keeps their maiden name and appends their new last name? For example, let's say MARY JONES gets married and changes her name to MARY SMITH JONES OR MARY SMITH-JONES. I need to match "SMITH JONES" or "SMITH-...

I am using a Link Partitioner to split an input file into 2 output files. The input file has 977 rows but the output files have 469 and 438 rows respectively. I am using Random as the Partitioning Algorithm. When I use Round Robin I get a different and also incorrect result. The flow is: SeqFile -- ...

Can anyone suggest a SQL statement to select the Information Analyzer Frequency Distribution values for a column using only the Project name, Table name and Column name WITHOUT having to use the cryptic names like "08-3a0e-4ee8841ae0ba1a450b_FD"? We are wanting to report FD values for colu...