DSXchange

iwin,

You could try filtering all characters that have a value of greater than ASCII (x7F). Those are generally considered the 'special' characters that can cause grief in downstream processing.

http://en.wikipedia.org/wiki/Ascii

Rob W.

Poorna, Are you trying to test for the presence of the string? Or perhaps the location of the string? You could do: MyString = "This Job Extracts New Employment Data for the Processing month Based on Current Month File" Position = Index(MyString, 'Employment', 1) This would return the posi...

On the other side of the issue of the 'Search' facility, I would suggest that there have been a number of times when posters feel compelled to chastise members for not using 'Search' when a brief look at their join date indicates that they have been members for quite some time. Veteran members need ...

Poorna, What specific information are you looking for to do your inpact analysis? For example, are you trying to determine what the inpact of changing the name of a column in one of your source/target tables might be to your code? There is a tool called Reporting Assistant that I used with some succ...

Ravij,

Do you know the names of the files coming in, or do they match a pattern?

Are the input files the only files that will be in the input directory? Do you delete/move/archive input files after processing.

Different approaches would be taken depending on the answer to these questions.

Rob W.

I think I'd stick with the KISS rule on this one.

Why don't you try:

if Index (tpo_loan_orig_out.PRODUCT_DESCRIPTION , 'alloo', 1) > 0 then 'Y' else 'N'

Rob Wierdsma

Try

YourInputString [1,3] : '-' : YourNewVal : YourInputString [2]

What happens when you run your SQL using your favourite SQL Utility? Cut and paste the SQL from your ODBC/OCI query stage into the SQL utility (what backend is Siebel hosted on? Oracle?). Do you get 76 records or 68? If you get 68, the problem is with your SQL query. If you get 76 rows, the problem ...

Sunshine, From your example above, it appears that your data streams have the same format. If this is true, use a collector stage to bring the two sources together and feed into your OCI. Could look something like: Seq ---> Xfm \ \ Collector --> XFM --> OCI / OCI ---> Xfm / You wouldn't even need th...

In DS designer, go to the job properties. In the dialog box, on the General tab, there is an 'Allow multiple Instances' check box. Check the box. The next time you run from designer or directory, you will be prompted to enter an instance variable. If you are running from a script, append a '.instanc...

Just had an issue similar to this and used this thread to find the answer. Using standard technique described elsewhere in this forum to compare keys values between rows, i.e. Stage variables ThisRowValue var1 : var2 : var3 IsDuplicate if ThisRowValue = PrevRowValue then 1 else 0 PrevRowValue = This...

I remember now, it was a lookup, not a data source, that this applied to. Of course, only one row can be returned in a lookup. If only the first of multiple rows is required, Oracle will do the sort after the rownum = 1 psuedo column.

If you are hitting Oracle with the OCI and need to get the first record based on a sort criteria, you might decide to use custom SQL to sort the data. This fails because Oracle picks the first record BEFORE doing the sort. Have to use the RANK function. Can't remember the exact circumstances under w...

A database doesn't really have a "last" record - at least not until you give it sort criteria. If you have the sort criteria and invert it your 1st record is the one you want. Actually, this doesn't work in Oracle. It determines the last row before the sort. You have to use other, more ar...