Mithinti replied to AK's discussion Concate two string fields and applying substring on resultant field in DMX
"Samantha Kastin explained very well . I just want to give you over view on high level.
--------------------------------------------------------
First change the DMX Task from COPY to JOIN transformation.
You can see left and Right sources in the tas…"
Apr 2
Mithinti replied to Ng Kar Ho's discussion MSSQL to CSV via DMX in DMX
"Cool .. Thanks for your updates.
What exactly you used in "Reformat"  Componrnts ?  .. I just want to know what is the exact issue and it's solution. 
Please share your experience on this issue.
 
Thanks,
Mithinti"
Mar 12
Mithinti replied to Ng Kar Ho's discussion MSSQL to CSV via DMX in DMX
"Hi Ng Kar Ho,
I can see 2 issues in your attached file
1)Special characters 2)Space between each letter
If you are talking about 1st one :
I am sure that It is not because of format issue or Endoing related Issue while loading into CSV FLATFILE.
The…"
Mar 9
Mithinti replied to Manjunath N S's discussion TPT Stream - Modify .tbuild in DMX
"Hi Manjunath,
You have to create a new connection template with TTU using below options
DBMS: TeradataAccess Method : TTU
Once you have created connection template ,you need to add that connection template to Target table .Once you add TTU connectio…"
Jan 22
Mithinti replied to Mithinti's discussion New suggestions for upcoming DMX versions in DMX
"I will give more details for my above second point .
While trying to use lookup in target reformat we have to apply join condition to retrieve lookup column .So that time while trying to use TRIM on both sides DMX not allowing to use that. So to do…"
Nov 3, 2017
Mithinti replied to Hameed Mohammad's discussion Help with DMexpress for creating sequence generator in DMX
"Hi Hameed,
Here I need few details on you data load process into Oracle table , Is it Truncate Insert ? Or Insert load(Maintain History) ?
If it is Truncate insert we have option in expression builder called "TargetRecordsNumber() " which generate n…"
Oct 19, 2017
Mithinti replied to Vicky's discussion (TERMMISSING) record terminator is missing for the last record of source in DMX
"You are using 2 files as source , May be possible that You are using MS-DOC for one file and UNIX for another file. Just check from your end. 
It's about file format issue."
Oct 19, 2017
Mithinti replied to Vicky's discussion (TERMMISSING) record terminator is missing for the last record of source in DMX
"Hi Vicky ,
Is that file was created by you or it's from source systems ?
If it is by you you need to maintain proper CR and LF accordingly . 
If it is from source system just change the "FILE TYPE" from UNIX to MS-DOS(Vice versa) source file."
Oct 19, 2017