DSXchange

Hi, Welcome aboard. Search the forum ,for your queries. Sample from the forum..... A hash file can simply be described as a file that distributes data throughout a pre-sized and space allocated file. Every row has to have a key to determine where the row will reside within the file. This key is run ...

Hi Rafi,
To add one more to ray's soln
FMT("flat file amt column/100", "L2").



Regards
kcs

Hi Kris,
Here is an example of builtin Transform function which converts the given Timestamp format (YYYY-MM-DD HH:MM:SS) to Internal Time format.

Example: TIMESTAMP.TO.TIME('2006-01-03 16:39:59') => "59999"



regards
kcs

Hi Guys, Thanks for ur replies. The Before SQL and AfterSQL tabs as well work with DML not DDL. User-defined SQL must be DML, not DDL. DDL is handled by other means (depending on what stage type you are using). I replaced ODBC stage for OCI stage, And sql statements like Create Table xxxx as(Select ...

Hi,
Clear Table then insert rows options will be slower because of transaction logging.Try Truncate table then insert rows options.


regards
kcs

Hi, I searched the forum under the topic user defined sql but i didn't get any solution to my query. My job looks like Oracle ------Transformer------Oracle Source table has 4 columns and Target table has 3 columns. Iam using user defined sql to Create Target Table and Load Data to that. CREATE TABLE...

Hi, Is your source file have similar pattern,ie delimiter variation is only in the second/string field. 001,ravi,kumar,98 002,ramkumar,34 Assuming u want output to be like this below, 001,ravikumar,98 002,ramkumar,34 Define ur source file with 000 delimiter -single Column. Declare StageVariable to h...

Hi Chowdary,

Before using RowProcCompareWithPreviousValue sort your data.


regards
kcs

Hi Chowdary, You can also use Transform function RowProcCompareWithPreviousValue to ignore duplicate values. The routine will check the supplied value with the previous value. If its same, then 1 is returned else 0 is returned. In the Transformer Stage,declare stage variable as RowProcCompareWithPre...

Hi ArndW,
Thanks for ur reply :D .


regards
kcs

hi Sumeet,
can u pls explain what u r trying to do?
what did u see in ur log?

regards
kcs

Hi suresh,


Use double quote within single quote(' ')
Ereplace(source.Field001,'"','')


regards
kcs

Hi suresh,
If u want to remove double quote in the Transformer and pass the data,use Ereplace function in the Transformer.

Ereplace (string, substring, replacement [ ,number [ ,begin] ] )


Regards
kcs

Hi,
To know whats happening....
View the job status of "Testjob" in the DataStage Director.


regards
kcs

Hi Anto,

Give the constraint (DSLink4.No <= "105") for clean Data
and use reject row option for the other.


regards
kcs