DSXchange

Please let me know whether merge stage allows left outer join and inner join.

Do we have any routine or function similar to DSSetUserStatus in paralle jobs or px transformer??

Do we have a routine in parallel which is similar to the one in Server Jobs i.e for eg SetUserStatus(%Arg1%) ?

GJ_Stage wrote:Hi ,

Can you explain what is the flow (i .e what are the stages are used) to create this seq file.

Got the solution...record delimiter string =DOS prompt has to be selected instead of record delimiter =unix newline

chulett wrote:Where are you looking at the file, on Windows? ...

Yes

Hi All, When I am checking the text file created in one of our jobs the records are written as below example Col1 Col2 Col3 111,AAA,Y 222,BBB,Y 333,CCC,N First line with column names and the records are written in the same line instead of a newline. What could be the issue? format used Delimiter =co...

source data : ColumnA ----------- 111 AAA 222 BBB 333 CCC Output: Col1 Col2 111 AAA 222 BBB 333 CCC I assume we can achieve this with the design Src-->Txfm (constraint alpha and num functions and generate dummy column with sequence numbers)----> numbers& alphabets------merge--->col1 col2 I am st...

It is always good to use null(yes) for output columns in lookup stage so that you can capture NULL for non matched records otherwise you might endup seeing '*******' for date columns and empty string returns for varchar fields and 0 for numeric fileds

can we use same stagevariable names in one or more transformers in a single job?? FYI it is not an interview question..just flashed in my mind while working on stage variables.If yes ,then each stage variable pertains to that particular transformer similar to a variable used in object oriented progr...

Thanks!! :D

I have to develop a sequence where nested loops have to be incorporated.would the sequence allow multiple start loop and end loop acitivies in one sequence?

chulett wrote:

srinivas.nettalam wrote:I am not convinced that it can be read parallel and I assume there would be lot of discrepencies in generating the sequence numbers in this scenario. Am I right?

Short answer? Nope.

Thanks

Hi All, I recently shifted my company and here I have been told that they are running few jobs that copy data from source to a landing area.All these jobs run parallely and read same state file.Also they mentioned if the surrogate key generator generates a number eg 100 in the first job it doesn't g...

soumya5891 wrote:Check the nullability defined in the Output column.It should be null.

just to handle that i am handling null in the derivation so tht it always has values

viswanath123 wrote:U might hve confused with that.. Normally Null handling is done for Nullable fields.

I meant not nullable field in the end not from the input..sorry