DSXchange

Hi Arndw, i applied the NLS setting with same code page but same is not appearing while loading in table. Is this something DS is not set to support that code page. i have checked all the installed code page by iconv command and can see same 8859-4 in the list. not sure how to proceed further. Any m...

yes and solotion reached till unix, DS loading is still issue.

quick input is much appreciated!!!

I have tried with IBM1112 Estonian char set.
is this somthing wrong with DS NLS setting. if we changed code page it should read it properly.

Hi, File is on mainframe server. I am ftping it to UNIX server by simple get command. The job loads a simple Teradata stage table. The NLS setting on source system level is set to NLS IBM1112 and on ETL ( Datastage and TD) server is ISO-8859-1 i.e UTF 8. When i tried to change NLS ( from ISO-8859-1 ...

Hi,

any input are much appreciated!!!

Br,
Devesh

yes craig i can do those changes in DS jobs but those required some testing effort.

Still thinking to achieve this from TWS side.

Hi all, Pardon me if my query is irrelevent for this forum. i have series of job sequence scheduled in tivoli for daily file arrival. eg: Monday seq1 (related appid in tivoli)--->seq2(related appid in tivoli)--->-->seq3(related appid in tivoli) Repeats till Sunday. Now there is one source which push...

Hi Ray,

i am using 8.1 version so no looping there.

i have tried using x'mer by holding previous column value but i need to select between role 010 and 230. there are other column value are also which is not satisfying.

please suggest

We have input; Cust_Id Policy System Role 1 a b 010 1 a b 020 1 a b 230 2 c d 010 2 c d 020 2 c d 030 3 e f 010 3 e f 230 4 g h 230 We want to take through 020 and 030 as standard so no worries about them. If there are roles 010 & 230, we only want to take 230. If we have 010 without a 230, we s...

@dvpawankumar---i already have the scripts but end user support team lack knowledge of unix and forcing us to achieve with DS jobs. @jwiles--i have tried with folder stage but output is only picking the last corresponds records only. @bhasds - Thanks for detailed solution, much appreciated !!!! will...

Hi All, i have situation here, not sure whether parellel job can handle this. file_name column is actual file name and record is there correspondance record, now i have to capture each data seperatly in respective file given below also there order should be retrieved as it present in input file inpu...

Hi All, I have come accross one scenario, kindly help me to solve it. i/p Emp_id IN_Time Out_time 1234 09:30 10:30 1234 11:00 14:00 1234 15:00 17:00 1234 17:30 18:30 O/p Emp_id IN_Time Out_Time Productive_time Idle_time 1234 09:30 18:30 7hrs 2hrs regards, D

Its Pre-look up condition
so its carried in Look up satge only

NullToZero(total_row_Amt)=NullToZero(Source_TOT_AMT)
Anything wrong in this?