DSXchange

@Madhav Yes I need to concatenate in the correct order like here AACC only. And I tried your logic; sorting on Hash partitioning on Acct_no asc, Rec_no Desc but I cannot just filter the data based upon Apply filter condition to difference=1 because if you see my data then row#1 and row #4 should be ...

@Pandeesh I need to check with the previous value. @Prasson and Madhav I need to apply this logic Acct_no wise so I need to take the acct_no in the stage variable too. Also I need to concatenate the value of Descript column with the same the diff. between previous and current Rec_no is 1(This can go...

Hi, Structure of my table is: Acct_no|Rec_no|Descript 100|10|AA 101|20|BB 100|9|CC 100|7|DD 101|19|EE 101|18|FF 102|30|GG The reqirement is for a particular Acct_no if the there are multiple Rec_no and if the difference between rec_no is 1 then I need to take the record with lowest rec_no. Also the ...

That is also true.

Or you can use this one too

@Pandeesh
The following example will make you understand

As Zulfi has mentioned, trim functions removes the leading and trailing spaces and reduces multiple spaces embedded withing the characters to single occurrence. There should not be any confusions now.

You can also use Oracle Connector stage as your target since it also works in parallel mode.

This type of data connectivity is always from ODBC. if you want direct connectvity then you have to use database native connectivity (Database Catalog). In odbc.ini file you wil find al types of data connectivity DSN with properties and in UVODBC.config file you will get DSN names only which you wan...

Keep your settings as follows: Partition read method :Rowid Range Increase your array size and row count 20000 and 40000. and check it. as per the server idle ratio, increase the count of array size and row count. do not enter any value in below two checks. 1>Table name for partition reads. 2>Partit...

You can start with below. No of nodes = Half the number of cores. Means that I can use following combination. 10 cpu =20 Nodes and 9 cpu =18 nodes. So can I use 20 +18=38 nodes for loading data ? or It can hampered the performance while using 38 nodes. How can I get the information that how many no...

Yes, it is..
But the default colors looks better than the new one..

Hi Ray/chulett , Thanks for reply. I have resloved the issue after performing below steps. a) `cat /.dshome` b) . ./dsenv c) ./bin/UVdelete VOC DSR_TRACE_IS_ON Is it possible that the customer has 'somehow' enabled server-side tracing in the template project VOC. This would result in server-side tra...

Dear All, Need some information about datastage configuration file. We have 2 DS+QS engine . Engine 1 containing 10 core(CPU) and engine 2 containing 9 core (CPU) with 40 gb ram on each server. While running job what configuration file we have create so that we can take the advantages of processing ...

Yes we can change the color of the links (attached, unattached), job running status not only in server but in parallel jobs too.