DSXchange

Hello All,

I know 11.7 supports Amazon S3 objects (indirect way to connect Google cloud bucket).

Does DataStage 11.7 support / integrate with Google BigQuery and Google cloud bucket objects or any other Google cloud services?

Datastage Superstack Information IIS RHEL 2019p0 (IIS Version 11.7)

Craig and Ray, thank you very much for your response. The expectation is after we place XML output into staging table or staging file we would like to do some transformation and feed the output to target web based system either in the form of XML file or JSON string. Please tell which one is suitabl...

Hi,

We are extracting data from a website I.E using hierarchical stage/XML stage and want place it in staging area.

XML file may contain 200 rows

Where should we place this staging data ?
Is it staging files or staging table

Which one is best approach?

We are planning to request new Information Analyzer production environment, Is there any guidlines we have which will help to request new environment especailly how many CPU requried , how much Memory required , how much disk space requried.

1) We have a requirment in that different regions ( say US , UK , HK ) have separate IA environment , In each environment regions specific Customer data anlysyis rules will be executed , We know the column metrics will be stored in XMETA , 2) We want to report all the different Region Metrics at Gro...

vmcburney

Thank you very much for the above details ,
1) we are looking licence for non production environment

Is there any IBM link which provide above details.

Regards
Ramesh

I am new to software licence procurement process. Need details on IBM InfoSphere Information Server 11.3- Can any body help on this 1) We would IBM InfoSphere Information Server 11.3 software along with following clients, clients IBM Information Governance Catalogue IBM Blue Print Director IBM InfoS...

Charecter "[" is single byte or multibyte charecter

The last byte of the EBCIDIC source filed ( EX. FIELD1 decimal 9,5) is null indicator, Which will be hex "00" if a value is held, and a "?" character (hex "6F") if the field is null. example 1) There will be 5 decimal places. So 1234.56789 will be held as hex "1234...

MY job desing as follows 1)CFF STAG--------2)TRF-------3)SEQ_FILE 1)a) Please find the parallel schema of the my INPUT CFF STAGE as follows . record {record_format={type=implicit}, delim=none, quote=none, binary, ebcdic, native_endian, round=round_inf, nofix_zero} ( copy_of_complex_flat_file_39_reco...

CFF stage supports one OCCURS DEPENDING ON clause. So what's the value in COL7 ? ... Hi chulett/Ray, Thanks for your help Ray where COL7 is lenth column new issue -- when I read this group column i.e. GROUP_COL1 in target I am getting following error in tranformer any idea , how to read the field G...

I am reading CFF with following copy book 01 Header. 03 COL1 PIC X(1). 88 HED_REC VALUE 'A'. 03 COL2 PIC X(02). 03 COL3 PIC X( 08 ) . 03 COL4 PIC X(10). 03 COL5 PIC X( 08 ) . 01 Detail. 03 COL1 PIC X(1). 88 DATA_REC VALUE 'D'. 03 COL2 PIC X(2). 03 COL3 PIC X( 8 ) . 03 COL3 PIC X(30). 03 COL4 PIC X(1...

Hi Ray, It is not an issue to achieve if my source and Target is DataBase, which will be easy to identify the existing record to expiry it .This Requriement is more or less equivalent SCD type2 , Main issue. My source is Flat file and target is DataSet - so I am not sure how to find the existing rec...

History Expiry issue Hi All My input is sequtial file and the data is like this. SK/natural key , Effective Date , Balance 20031 2015-09-07 1.33 20031 2015-09-08 4.2 20031 2015-09-09 6.9 I would like to have my target in the following table Assume History ( Composit Primary Key is 1) SK/natural key ...

chulett wrote:Yes. Filter any 'empty' records post-pivot. ...

Can I know the root cause why we found one extra record