DSXchange

Hi,
I am getting date fields actually text fileds with various formats MM/DD/YY and YY/MM/DD . I need convert them to DD/MM/YYYY.
Please can any body tell the functions need to be used in converting date format and check the date ISv alid

I am getting date from my source file as MM/DD/YY. How do i check the Date value.
Transformation rule:
Datae cannot be in future, If future rejects . If blank set to default value

Hi, I am reading data from mainframe system. we are getting negative and positive value for partcular column. What are functions do we need in transformation stage for checking the Positive and Negative value of a particular column Transformation rules: Number must be postive value, if negative reje...

There is no limit for the version Number. For new record it has version number=1.

We are extrating source from legacy system and loading into DB2target database. Ex: one of the table structure of POSTAL ADDRESS TABLE in Db2 like following: ID,ADDRESS_CD,ADDRESS1,ADDRESS2,CITY NAME,STATE,EFF_START_DT,EFF_END _DATE,VER_NUM 1,Mailing,xxx,xxx,TROY, MI,1/11/2012,2039-12-31,1 I am usin...

When binding output interface field "CLAIM_ID" to field "CLAIM_ID": Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use the modify operator to specify a value to which the null should be converted. Hi i have Source comming from dataset h...

If your job is trying to load rows into database table. Then you need to contact with DBA regarding the size of the table

Hi,
If Someone have expertse in Mainframe. They can change the hexadecimal data into ASCII format.
So you cannot read the hexadecimal from Sequential file . It need to be converted in Mainframe itself .

Use NullToValue() function to provide a value that indicates that the source was null, perhaps -999999.99 (or any value that will never occur in your real data). Hi Ray, I used NullToValue(to_xfm_Map.CLAIM_ID,-9999) finction in transforamation stage at column Derivation Part still i get error ,mess...

ray.wurlod wrote:Use NullToValue() function to provide a value that indicates that the source was null, perhaps -999999.99 (or any value that will never occur in your real data).

Hi Ray,
Thanks for the reply
Just i have one question where should i use the function NullToValue().

When binding output interface field "CLAIM_ID" to field "CLAIM_ID": Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use the modify operator to specify a value to which the null should be converted. [/b] Hi i have Source comming from data...

You seem to have a mix of delimiter characters in your data ("|" and ","). You may need to read the start date and end date as a single field and parse them subsequently. Also check that the correct delimiter (as per your metadata) terminates the transaction date field. Hi, Just...

Hi, I have one issue. My source is a flat file. My lookup is Db2 database. i have Source column which is Char datatype with 9 chars. But my lookup up table column is Varchar data type with 15 in length. My question is how can i trim the spaces and lookup based on the condition. As far as in server j...

Hi, I have source File which is flat file i am getting some warning messages; Please some one can hel me out source: falt file delimiter: |(Pipe) Final delimiter: None Source as follows: CUSTOMER_ID|CUSTOMER_NAME|TRANSACTION_DT|STR_DT,END_DT 1|UMA|1/1/2010|5/20/2010|12/20/2010 1|UMA|5/28/2010|5/20/2...

Hi, My source is flatfile . I have date data in varchar type iin my source. My goal is covert the varchar to date format and vheck for valid date format (%yyyy-%mm-%dd) In Transformation In Constrains I used following IsValid( DSLink2.Date,TrimLeadingTrailing( StringToDate(DSLink2.Date,"%yyyy-%...