Varchar length changing

  • Hi Guys,

    AS is not my strong suite so bear with me if I am talking nonsense.

    If I have a cube tht was originally built, processed and deployed where a field was a VARCHAR 50 and that source field gets changed, either to varchar 20 or varchar 100, what will the result be? will it fail on either oor both when next being processed?

    thanks

    Ian

    Ian Cockcroft
    MCITP BI Specialist

  • Question:

    how does the source varchar table length just change on the fly? :ermm:

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • no it didnt, we changed fields in the warehouse and were wondering what the impact will be on our cube and reports.

    Ian Cockcroft
    MCITP BI Specialist

  • as long as the DSV refreshes the updates from the source fields, I don't see any possible issues.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply