DSXchange

Ray - I just want to convert seq file into xml , i gave all the schema in the Description for each data element and i am using the same job flow as you said seq---tx---xmloutput . In my output i am getting first record in xml format starting with <?xml version="1.0" encoding="UTF-8&qu...

Hi All, I am trying to convert a txt file comma seperated into xml , what are the steps i need to follow.

Thanks in advance

I hope this could help you viewtopic.php?t=113381&highlight=date+file+name

what part of my post you dint understand ?

You should have post this in server forum to get better response, are you getting any issues with the constraint you provide ?

looks like you are joining two columns of same name so thats why it is dropping that colunmns , try to change the name of the col you want to join in reference or source data set and then try.

What are the properties you are using in CDC ? i think the change value property should be 'Explicit keys and All values'.

Try the derivation given by ArndW and another way I suggest to do it as a substring, like date and time. U can change the date by using stringtodate() and keep the time as string to tranform it for am/pm using stage variables.

Can you please post the error you are getting ?

What is the compiler you are using ?

For int if the look up fails it give 0 if u want null instead of 0, u can convert it in the transformer from valuetonull ,as for data types try using Cont_Id as decimal (lenght,0) .

Check that all the properties , data types and keys in both input files are same and change the CDC property tp Explicit Keys, All Values as suggested by minaj if u want to compare all the columns.

In your target stage you will option for open command (sql executes before loading the table) and close command (sql executes after loading the table), since you need to delete the those entries with id 1,2,3 before loading the table you can use open command to sql for your criteria.

I am runnning a PX job in which i am doing a lookup to SQL server tbl on a certain where condition ,i want to select only first one row from the table on that condition and i want to do that in lookup stage or transformer but not in sql server stage..how can i do that any suggestions will be appreci...

You can use TimestamptoDate() function if you want only date part from your input timestamp and you can specify your default date format in your target stage.