DSXchange

anbu

Input --> Aggregator --> Transformer --> Output

- Get Min and Max from aggregator
- Use Max in Transformer looping and generate all the values

anbu

I think you should have 14 on this line "all,c,10" Input --> Transformer ---> Aggregator --> Seq Have three output links to transformer. In first output link, have this mapping Field1 --> Field1 'All' --> Field2 Field3 --> Field3 In second output link, have this mapping 'All' --> Field1 Fi...

anbu

If you use Join stage, you will get all the duplicate values by default

anbu

Source --> Transformer1 --> Pivot Enterprise --> Transformer2 --> Aggregator --> Target Transformer1 : Create derivation like this for all your fields wherein hard-code your field name in Else If NullToEmpty(Field1) = '' Then '' Else 'Field1' Pivot Enterprise : Do horizontal pivoting with Derivation...

anbu

Hi Members,

Any one has experience in the following migations?

IBM Cognos Decision Stream V7.1 to IBM Infosphere DataStage v11.3 &
IBM Cognos Data Manager V10 to IBM Infosphere DataStage v11.3

Any help is much appreciated

Thanks,
Anbu

anbu

I have to parse Spanish Characters from my input( TSV/Excel ). RCP is set on source sequential file stage. Can you please advice how to set Extended property to Unicode for Varchar cols in Schema file?

anbu

Try this command in filter

Code: Select all

awk -v dt=$(date +"%Y%m%d") ' { print > dt"_data.txt" } '

anbu

Reject files are always created. Use an after-job subroutine ExecSH or ExecSHSilent to execute rm command to delete reject file if it is empty

Code: Select all

if [ ! -s /Path/Reject_file ] ; then rm /Path/Reject_file; fi

anbu

Are you selecting only two rows?

Code: Select all

Select empno,NULL,salary from emp where Ename =Peter 
Union All
select empno,salary,NULL from emp where Ename=Reddy

anbu

What is your input? Table or File?

anbu

Either verify it manually for all columns or import metadata through Orchestrate Schema definitions and reload metadata on source stage

anbu

Leading zeroes will be removed from Int columns. If you want to have leading zero, then define it as varchar column in DB2

anbu

DS 9.1 is lot stricter on datatype. If your metadata in the job doesn't match your table then you will get these errors

anbu

Change precision and scale on source connector stage to match column datatype on database

anbu

Use Decimaltodecimal() to convert precision and scale to match column datatype on your target database

DSXchange

Search found 592 matches

Migrate Cognos Decision stream and Data Manager to Datastage

Extended property to Unicode for Varchar cols in Schema file