DSXchange

Hi, I went through all the related posts I tried rebooting,deleting all datasets and other things suggested, but that havn't got my problem solved. I have around 1200 jobs to populate the warehouse. I combined all the jobs in form of sub sequences and then to a master sequence. But when i am trying ...

Hi, We are Joining table A Full Outer Join B..and target fields are from both the tables.There are couple of records which are not matching Join and are coming with NULL Values for the fields which are coming from A &B.I tried NULL Handling but records are again getting dropped. Suggestions are...

Yes, greater volume of data but not that much. At the time of development they are using only joins and at Query level. they are not using any other. All the logic was inserted in query. Not using any stages only transformer stage. Havn't got all the answers :? Greater volume of data will increse t...

My source is fixed width binary file(.txt). For few columns I am getting Blank space from source which is not getting trimmed nor isnull() function is not working on that field. What function i can use to identify this value as i need to populate a default value when there is a space. as ArndW said...

Why not prove it either way? Run the job with Force set and not set, capturing and examining the Score. Which one has no copy operator? (Note that the Copy stage must be a straight-through copy (no ... For my scenario it s giving me the same output in both case. Examining not only contains examinin...

Actually i was doing a division operator on a varchar data type and even used type conversion function to change it to decimal data type. StringtoDecimal(). Still in the sequential file i could see leading zeroes. My decimal data type is of length 12 scale 8. yes the decimal data type ammends leadi...

Hi, In Copy stage whats the difference if i keep the set Force option as True or False. I have a Job where there are one input and two Output to copy stage. In this case shall i keep the Force option as True or False and why? Thanks Setting force option "True" Specifies that Orchestrate c...

:idea: You can use dummy column to join the two files..... Add this column in both the file..say the name of the column is colX with value as '1'. Us join stage which will join the records based on this dummy column.. dummy column may lead to cross product its better to use Ray's suggestion if numb...

It's one of several reasons why I keep using Transformer instead of Modify stage. The cost of using Transformers have been vastly reduced over several versions, and is ideal for handling data automatically. Teej, Yes The cost of using Transformers have been vastly reduced over several versions, and...

I was trying to get the maximum value of a timestamp field in a file for later comparison. But while doing that the aggregator is trying to convert the max value to double datatype. How can i aggregate the timestamp value and map to the timestmp filed. I need to get the maximum value of a TimeStamp...

When I used TrimLeadingTrailing function for any any nullable column like TrimLeadingTrailing(toXfm.Employee_discripion) I got the below message. "Xfm,0: Numeric string expected for returned value from function call 'substring_1'. Use default value." This is not a warning message but why ...

ArndW wrote: but that is more a matter of personal taste than anything else.

Thats true

any ways i will try both ideas

yours as well as mine

let's see which takes least time

Thanks and Regards,

Priyadarshi - this is a reject link he is asking about, where the attributes cannot be changed. ... thats why i suggested to use a copy stage. i know i haven't written it precisely but i have suggested to use a copy stage i think using a copy stage is better than using modify or transformer if not ...

Hi, I have a set of 20 to 25 long running PX jobs (each job runs from 3 hours to more than 5 hours). I have been asked to look at ways to improve the performance. I observed that the Double datatype had been used as a default for most dollar fields in the jobs inorder to avoid arithmetic complicati...

Put a Transform or Modify stage at the end of the output reject link so you can change the column metadata and values as described by dspxlearn. ... Transform will reduce the efficiency double click on the row number to get all the properties exposed there put the null handling details like null fi...