DSXchange

Does that actually work? I'd be surprised if it does, because the '%' wildcard character presupposes a LIKE operator.

Define "performance" in an ETL context.

Under the covers both use OCI calls (assuming that DRS is using Oracle rather than ODBC as the database type).

Open Director. Sort by date/time. Print to file.

And your point is... ?

IBM could not begin testing until August 2009, based on that timetable.

There is support for Windows 7 in Foundation Tools 8.1.2 (recently released) - doubtless for other products in the suite in the next-released version (first half of this year).

Stay tuned.

No idea. Because I have never encountered this variable. How about you go back to IBM, to whoever gave you the advice, and ask for more information, ideally a reference to documentation? Then post here what they tell you.

There is a mismatch between the number of parameters specified and the number of parameters required.

Please also be clearer about what you mean by UNIVERSAL.

Does AMERICAN_AMERICA.AL32UTF8 really handle Chinese characters?

RESIZE is always in VOC. So you don't have to worry about that.

I'd be more cautious and check first that the characters occur only on the ends. If InLink.TheString Matches \'"'0X'"'\ Then InLink.TheString[2,Len(TheString)-2] Else InLink.TheString Using substring allows for the possibility that there are double-quote characters within the string as wel...

karthi_gana wrote:I have a file which has two field.

report_code integer 10
report_name varchar(255)
field_value varchar(255)

Attention to detail is very important in an ETL developer.

Welcome aboard.

There are at least two choices.

• Use substring and concatenation to build the correct date format for the database.
  
  Convert the string into an internal date, and specify Date as the Data Element for the database column.

... making sure you use a key-based partitioning algorithm and sort on the key (in this case a stable sort is indicated).

Be more precise about the actual error messages. For example you may be supplying values for parameters that are actually not legal values, such as "FRED" for a Date parameter.