DSXchange

Hi All,

My input is like
1,gg,3
2,hh,2
3,hh,1

3rd column name is value an my output should display according to the value of that colmn.


here o/p i slike
1,gg,3
1,gg,3
1,gg,3
2,hh,2
2,hh,2
3,hh,1

Can anybody help me the logic for the above.

Thanks,

Hi All,

I would like to know how to delete the filesets.
is there any command for that like orcadmin for datastes.
Please let me know..

Thanks,
Rajashekar.

Hi All,

With out using funnel ,merge we have to combine two datasets ,by using orc admin utility..
Can anybody tell me solution and in the future we should not get any data issues.

Hi All,

Can anybody tell me conversion function from CHAR to INTEGER in modify stage.

Specification i need.

Thanks in advance..


Thanks,
Rajashekar.

Hi,

I am getting the data like 80.123,23.123
means after decimal point i am getting 3 digits ,i need to multiply the data and get the results up to 3 decimal point only(121.122).
source is text file here.
do we have any functions for this transformer..

Please let me know..

Hi All

When i tried to read the data from seq file i am getting the following warning.

Import consumed only 14bytes of the record's 80 bytes (no further warnings will be generated from this partition)

Job completed successfully.but getting the warnings..
can anybody explain it..

Thanks.

Hi Can anybody send me the link for datastage 8.1 architecture.bec i tried in google but i didnt get the proper architecture..

that would be great if u have any document ,please send it...


Thanks in advance..

DB is DB2
Ds is :PX
Hi i am passing one parameter as date as a scheduled run date
when i give the format like yyyy/MM/DD it is accepting.but when i give format like MM/DD/YYYY it is not accepting..though i use datetostring function it is not accpting..

Can anybody help me out on this..

Thanks

HI Gm, V 8.1 i am joing 2 db2 stages by using join stage. but the problem is from left side key is nullable is no and right side key nullable is yes now i am getting the warning and fatal eror Join_21: When checking operator: On input data set 1: When binding input interface field "PARR_ID"...

chulett wrote:"sa" is your surrogate? Regardless, it is warning you that your target won't be able to hold all possible generated values. So, what is your target for this? ...

sa is output coloumn bame and after this i am mapping this to db2 table same coloumn.

thanks,

Let us simplify the problem and take the output out of the equation. Create a simple job with a row generator going to your surrogate key generator and then outputting the generated key to a PEEK stage. Does this test job work? Does your sequence (as defined in "source name") exist in the...

ray.wurlod wrote:Should the source be schema.sequencename.NEXTVAL ? ...

i tried with that value is also and i am getting thr error undefined value like schema.sequencename.NEXTVAL

please advice us..

ray.wurlod wrote:OK, please show us the properties that you have set within the Surrogate Key Generator stage. ...

db instance
db name
db userid
dbpwd
dbserver
source name: schema.sequencenumber
genarateoutputcoloumn
sequence :database seq


thanks

chulett wrote:Isn't one of the requirements to doing that that the stage must actually be used to create the sequence? If true, was that in fact done?

it should genarate the seq but itsn't....

thanks..

Please show the SQL you are using to insert the row, and indicate how many columns there are in your job design being sent to the database. ... HI We are able to insert through insert statement in the db2. But we are generating the sequence through surrogate key genarator where the increment value ...