DSXchange

Hi Mansoor,
I did play around with the combine record stage, but I am not sure how it will combine the columns into one row.

Thanks,

Hi, I read through the post but did not get the StageVar5 part, what if we have unknown/varying numbers. Below is my source, and I need to concatenate col03 based on Col01 and Col02. But the number of rows are changing for Col1. Col01 Col03 S1 1232 S1 123w S1 asde S1 dewe S2 asas S2 aswe S2 wewe S3 ...

Hi Craig,

Sounds good, one of our senoir developers also had an idea of using an external stage to read the column in and use parameters for values.

Looking at the options that are available.

Hi Andrw,

The column lenght is not always the same, its varchar(3), I dont get it when you say all columns, I am asking about just one column, which has multiple values and if there is a new value added in the source (like AAW) then I want to avoid changing the if statement in the job.

Hi,
I have a scenario where incoming column value needs to be compared, ex
If Src.Col1=A then 01
If Src.Col1=B then 02
.
.
If Src.Col1=F then 07

How can I parameterize it in a situation when the values of Col1 are dynamic.

Thanks,

Thanks guys !

hi, In the filter stage when I use the condition Col1='Sales #' it gives the below error: main_program: Data set, file set, or file "Copy_13:ToFilter.v": Non-pipe (or non-virtual data set) with .v in its name Data set, file set, or file "Copy_of_FilterFlag:Lkup_Flag.v": Non-pipe ...

Hi, I have got it working with the below format in a transformer, I was missing the space between the two columns when I concatenate them. StringToTimestamp(To.SrcDate:' ':To.SrcTime,"%yyyy%mm%dd %hh%nn%ss") Old format was StringToTimestamp(To.SrcDate:To.SrcTime,"%yyyy%mm%dd %hh%nn% s...

Instead of two modify stages and one copy satge , is it not better to use one transformer? In the transformer, the below function works with dummy time StringToTimestamp(To.SrcDate: " 000000","%yyyy%mm%dd %hh%nn%ss") but when I replace the " 000000" with a column it giv...

Hi,
I have 2 source columns
Column1 (Char8)=20060624
Column2(Char6)=174911

I need to write to an oracle table as a timestamp, is there a function I can use in Modify stage to either concatenate or convert the source columns to single timestamp output column?

Thanks,

When switched between View-"Extended Job View" , it lets you move the jobs !

Hi,
I have selected all tehjobs in one category and when I try to drag them over to another category in the left panel , it doesnt look like they are transfarable, are there any options that need to be changed?

Thanks,

Kris,
I didnt get it either, he is asking about what to do with the rest of the columns, like how to propogate them to the output link without using the derivations.

I was under the opinion that the API does not invoke the multi or fast load process.

Hi Ray,

In the TD enterprise stage, we can use DBOptions and set the values, where do you think we do that for TD API stage? In the config file , from where it reads?

Thanks