DSXchange

Hi All , We have nearly 1000 copy books . we import all copy books manually . Could you please provide suggestion to automate the below process. 1. Flattening 2. Schema generating from flattened table definition as below. Sample Schema file : record {final_delim=end, record_delim='\n', delim=',', qu...

distinct (unique in group )

Hi,
Even if it is distinct or duplicate ,i have to retain if a key contains same value in a group in link 1,Else retain the group in link 2

Yes
even if i have more than one distinct value i have to send in link 1

Hi, could you please help me to solve this . In particular group if any value changes I have to pass the particular group in a link 2 . If value doesn't change pass it in link1 Input : ------- Key | Value A|01 A|01 A|01 B|01 B|01 B|02 C|01 D|02 D|03 Output: ------- Link 1 : A|01 A|01 A|01 C|01 Link ...

Hi,
In T2 it won't have more than one value as default.
yes it like default value if it not match.

Is it possible to perfor join with or condition in datastage?

Eg :

T1:
a,b
1,2
2,2

T2:

a,c
1,d
0,e

i need o/p as:

if T1.a=T2.a or T2.a=0 then c
O/p
a,b,c
1,2,d
2,2,e

Hi,

If we need to check the 7.5 and 8.7 hased file. let we write in sequential file for both 7.5 and 8.7 hash file .we can compare both records.

Regards,
Manoj

Hi,
Better we go for join stage..

could u please give the correct information about the stage?

HI,
Use trim A function with below junk character it will remove all occurances

Thanks & regards,
manoj kumar

Hi , Could please conform which stage an which back end environment you are using Stages like (DB2 API, DB2 Enterprise) Back end like (unix,aix ,mainframe) why because in main frame environment we tried with DB2 enterprise stage we too face the same problem an we find that in mainframe environment w...

Hi,
Could you please try this in script and call this script in sequencer job
Script must contain this inputs :
Use looping concept
-----------------------
select count(*) from Table >D1
D1 >1
then
(
Delete from (select * from table fetch first 100000 rows only )

commit;

)

Hi, Could You please give the stats of this extract query in both Datastage and Toad ? Please index columns for Joins I am not sure about this table and it key column so i blindly giving this query.. WITH VAL AS ( KEYCOLUMNS,rn ) (SELECT KEYCOLUMNS ,row_number() over (partition by incident_id order ...

Hi, Could You please give the stats of this extract query in both Datastage and Toad ? Please index columns for Joins I am not sure about this table and it key column so i blindly giving this query.. WITH VAL AS ( KEYCOLUMNS,rn ) (SELECT KEYCOLUMNS ,row_number() over (partition by incident_id order ...