DSXchange

All, I have searched about this topic and found the below one which is saying datastage is very strong in 'T' and also datastage is not that much strong in Rule based. This discussion happened 7 or 8 years back. But the things are changed now. we are in Datastage 8.7 version. How about the latest ve...

I used Transofrmer and Constrait to do this. It works fine. But i just wanted to check is it possible to do in FILTER.

All, I have a requirement. We will receive country code as input to the input parameter. Based on that i have to amend some more country code. say for example, If i receive country code 'EU', i have to check like below EU = GB, DE, EU I have a dataset with country code column. If the input parameter...

All, I have read about value files here. I can't get the extact usage of value files. Do we need to create the value files manually? IF yes, a) Do we need to enter the path of that file name? b) what is the format of that file? I have both parameters and value files in my parameter set. which one wi...

All, We are using 18 databases for our project. Datastage job will load the data into ORACLE. The NLS setting in datastage side is UTF-8. Background: In the datastage job, we are using ODBC stage to load the data into ORACLE. we used NVARCHAR in 8 version. We recently migrated datastage from 8 to 8....

All, I am facing some strange issue in Datastage 8.5. When I compare two 'BLANK' i.e string only. it is always returning false. say for example, (If isnull(LkpEmp_Src_Fld) then 'BLANK' else Emp_Src_Fld ) dataset---->Transformer ----------------------->Lookup stage -------> dataset ('BLANK' --> Emp_S...

All, We are using Datastage 8.5 version. I am working on this version for the last 2 months. I have seen/faced many issue with NULL handling stuff in this version. I just wanted to share something here. My Code: NullToEmpty(Lnk1.Code) --> StageVar1 If Len(StagVar1) > 0 Then '1' Else '2' ->StageVar2 ...

ShaneMuir wrote:What is your left link? If multiple inputs have the same column names only the column from the left link is available for mapping.

You are right. I used the same name
After changing the name, I can see it.

All, My job design is as below file1 --> File2 --> Join (Left outer join = File 3) --> Remove duplicates --> File File3 --> I have added new column in both file1 & file 2. But it is not at all displaying in the Join stage "Mapping" - Output table. why? Even I re-compiled the job. But i...

LoadId={aborted run}

I am not getting this.

Do you mean LoadId <> 1 or is null?

can you give some more options to do the same?

Could you explain it in detail? it would be helpful , if you explain it with simple job design for both the method.

chulett wrote:How have you been answering this question in all those interviews?

nope

All,

I am facing this question in almost all the interview.

question is :

seqfile --> transformer --> odbc

seqfile = 10000 records

The job failed after loading 5000 records. how to load only the remaining records?

what is the proper way to handle this? we are using 8.1 and 8.5.

All, my sequencer job is used to call the parallel jobs based on the previous jobs status. i.e. RUNOK or RUNWARNING. JobActivity1 --> JobActivity2--> JobActivity3 --> JobActivity4 ---> JobActivity5 -->JobActivity6 is it possible to skip any job from the sequencer? say for example, i don't want to ru...

any inputs?