DSXchange

Hi, We are trying to load the encrypted data into netezza, but getting error due to bad rows. Can some one tell me how to load encrypted data into netezza. First we are loading data from oracle to netezza temporary table, then loading data from netezza temp table to netezza main table. While loading...

Achieved by the file name column property in sequential file stage

Hi, i am getting multiple files with the common structure, but my senior saying need to use the loop activity in sequence jobs and solve the issue.

Please let me know how to resolve by using start and end loop in job sequencer

Hi, I have a scenario like source file include date like ABCD10112016.dat . I need to derive that file date value '10112016' for one of the target field. Could you help how to reach, Moreover will get multiple files same day with different dates. 1job source files: ABCD09112016.dat ABCD10112016.dat ...

Hi Getting Host key verification failed while executing the DS through unix Please let me know in which scenario getting the issue, and whtat is the solvation. main_program: APT configuration file: /chdba/IBM/InformationServer/Server/Configurations/SANDM_2Node.apt { node "duccasedmet01_0" ...

I found the issue i am getting the control M char for that field and used below logic to remove the control and removing first three header rows in the file.

used External source stage

tail -n +4 #FileDirectories.SourceFiles#/File*.txt | tr -d '\r'

Yes, seeing the results in peek stage.
Source data type string and target data type decimal(15,10)

Please find below what are the option I tried.

Trim(column,' ','A')-- result '0.0'
String to decimal(trim(column))-- result '0.0'
Field(column'.','1') -- result ' 00100'
Field(column,'.','1'):'.':Field(column,'.','2')- result '0.0'

Yes converting the data ' 100.0' to '0.0' while doing string to decimal

I have modify the statement, is above one is ok (no confused) --craig

Hi, We are doing data conversion from varchar to decimal, but instead of data ,we are getting value '000.0000'. source data like ' 100.0000'(including space). My experiments I tried with the below options. strepwhitespace(Lnk_out_Unload_File.DISTR_PERC) trim(Lnk_out_Unload_File.DISTR_PERC,' ','A') w...

Yes it's working fine with the previous message logic mentioned logic


If from a single file, then set value of "Source Program" to
Quote:
tail -n +4 <path>UKRIPR*.txt


thanks

If i implemented that logic it's throwing the warnings like.

External_Source_14,0: Field "LAYER_LIM_AMT" has import error and no default value; data: {5 7 1 4 2 8 . 6 1 0d}, at offset: 209
External_Source_14,0: Import warning at record 0.

Hi, I want to be remove my file header(first 3 rows), please let me know how to remove header. My file name contains like UKRIPR*.txt, if i use with file pattern option i can't utilize the ' tail -n +4' command. above command works with only specific file option. let me know is there any other way.

Hi , While reading hadoop text file data from through File_connector stage getting below error. If I read same file from local environment, getting success. please help me to resolve the issue. ERROR:tproduct,0: An exception occurred: com.ascential.e2.common.CC_Exception: Failed to parse row 35,792 ...