DSXchange

Hi, We are currently using dataset stage for creating intermediate files in HDFS. The descriptor file is created on the edge node (Linux) and data files resides on the data nodes (HDFS). My questions are: 1) Do we have any I/O performance overhead since descriptor is not in HDFS and data files are i...

Thanks to all....

Prasson...i think when we put it as numeric type,it wont take leading zeros..i tried that solution..its working... r u sure prasson...??

Hi, In lookup stage,i used varchar column - MEM_ID as key column. The values of this column MEM_ID in main file and ref file is as follows. MEM_ID - varchar2(5) Main File: ======= MEM_ID MEM_NAME 1 prem 2 surendar Ref File ===== MEM_ID COV_ID 01 100 02 200 What would be the result..?? does the key c...

Hi, i need solution for the following scenario: i am having one main file and reference file. I need to lookup data based on specific value which may be in any column, not based on specific column... ie in lookup stage what happens is we give a key column with which matched records w.r.t that column...

Hi,

Thanks for your response.

But same job when i tried running with config referring 4 nodes, it hasa run successfully. But the problem araised only when we tried running with config file pointing to 8 nodes.

The prevailing problem is anyway related to that...??

I used a sort stage with hash partionning and after sorting the data , i used remove duplicates stage with same partition. I am encountering the error as "User inserted sort "LabResultMem_srt" does not fulfill the sort requirements of the downstream operator "LabResultMem_rdup&qu...

When itry to run a job which loads data into DB2 database from sequential file, i encountered the following error :

"main_program: The section leader on apsp8507 died"

what is this...? any solutions...??

In the director it is showing job status as "Running" for a particular job. But when i tried to monitor that job,it is showing as 'stopped' status in monitor window.... why does this happens....??? if someone have stopped that job...?? it should show aborted status... also chked that job.....

I got the error when i tried to monitor the particular job first and then again came when i tried view log details. But it came only once..i dont know why it has come....

Following error is coming when trying to view log for a particular job in Datastage director

"Stage Type BBB is being accessed by another user"

When and why does this error comes...??

Hi,

What is the functionality of DSLinkRowcount...?

plz provide the equivalent of DSLinkRowcount macro in parallel..??

Hi,
What is the difference between lookup, join and merge in datastage...??...which is more efficient....??

Hi,

Is bthere any altertnative to @INROWNUM system variable in parallel extender..bcoz it is not working in parallel.. what is the use of @PARTITIONNUM..?/

Hi,
Which file is better.....Lookup File set or Dataset or Fileset and when these each one is getting used to get efficient result ...??