DSXchange

Hello Everyone, I have an if..then..else expression used ina stage variable. The derivation is like if NullToZero(col1)=NullToZero(col2) then 'A' else 'B' The job aborted due to the error "Null handling function called on not nullable field" that message is in high level and I am unable to...

Hi,
Can anyone let me know whether External Source Stage can be used on windows server environment to pass filenames to XML input stage .Since "ls" is a UNIX command ,can we go for "dir"?

Thanks Priya :D

I am unable to trace the generated job report and the target path cannot be edited by the user.someone knows where can we get the reports from?
thanks...

Thanks Ravi for the update.I have implemented in the similar way.

you can use the formula below

@PARTITIONNUM + ((@INROWNUM-1) * @NUMPARTITION) +1

map this to your target column

Ravi.K wrote:Use the below command at fileter option of sequential file.

awk -F " " '{for (i=1; i<=$1; i++) print $0}'

Please let me know if my source is an oracle table and using v 8.0.1

Hi, I have a typical requirement.we have a column SLS_Q in the source and based on the value in the SLS_Q ,i need to generate that many no. of rows in the output. eg. if sls_q =5 then the same record should be populated 5 times(5 rows) with an addtional column seq.no which has values sls_q seq.no 5 ...

you cannot populate a value in the constraint.you need to write the conditions in the derivation for a field in the output.If you want to restrict the records on the conditions then For first o/p link contstraint : column (Role_ID) ='AAAAA' OR column (Role_ID) ='BBBBB' OR column (Role_ID)='CCCCC' OR...

Can we compare dates in datastage transformer derviation like
eg:-
1) link.datecolumn < CurrentDate()

2) link.datecolumn1 < 0r = link.datecolumn2

Please pardon me for not being clear with the question from the beginning. My question is only regarding the functionality of lookup stage only and not regarding any requirement. If the primary and reference have same column name as per my previous question ,and reference.EMP_NAME is mapped to ouput...

Does it happen only when "continue" is selected?what data would be present if any of the other options is selected?

PhilHibbs,
Thank you very much.

Sorry for not being clear.Here is my concern.Primary link has 2 columns EMP_ID ,EMP_NAME and Reference link has 2 columns EMP_ID and EMP_NAME.key to lookup is EMP_ID and EMP_NAME from reference is mapped to output.Though reference.EMP_NAME is mapped ,the data in that would be the data from primary l...

Hi ,
Please let me know whether the conception below is right.
If the primary and reference links have the same column names for non-key columns, then even though the reference column is pulled the data in it is the data from primary link's column.
Please let me know on this ....