DSXchange

Yes in transformer we can do it but without any function just use :

String1:String2

Make sure the record length every entire record is equal.

Eg. Record length 5

11111
222
22222

here the second record 222 must have 2 spaces at the end when reading the fixed width file otherwise it will get rejected

As far as I know concatentation is not possible in modify stage

Check the search option in dsxchange.com you will find solutions

Any help on this?

Ok.. thanks so a load from a dataset to an Oracle table can be done directly.
Thanks

Hi All,

I am loading data from a dataset to a Oracle table using a ODBC stage. I remember I read that its always advisable to use a active stage between two passive stages. Like a copy stage in this example of mine.

Can you advice on this.

Thanks
Devi

Oops I thought it was parallel job...

use the following and try

StringtoDate(Input.column,'"%yyyy-%mm-%dd')

Generally we use the factless fact when we want events that happen only at information level but not included in the calculations level.just an information about an event that happen over a period. Factless fact tables are used for tracking a process or collecting stats. They are called so because, ...

I tried running the job with the transformer stage having the routine. Yet get the same error Trn_Fetch_Max_Value: Failed to load the library "V15S0_EDQS_CIS_POP_COUNT_DS_Trn_Fetch_Max_Value.o"; either the directory containing the library file is not on the library search path, or the libr...

Also if you know that the last field value is a date of length 10 then take a substring to get the second field value

If I use a basic transformer to set the environment project defined variable what will be the impact on performance.

I even do not see the server routine of DSSetEnvPar to call it in the basic transformer

I tried that. If I have 8 rows from the reference link out of which one is the right one then the lookup shows failed on the remaining reference records. Also this would not display the error message correctly why the lookup failed.

How do I do it.
What would the condition be? If I do not obtain any value from the reference link I need to abort the job.