DSXchange

I have tried it again with the same SQL's...

eg:
Update;
Update

It seems to work...it doesnt complain!!!

Thank You for your feedback...

Can anyone let me know if we can put more than 1 SQL statement in teradata's OCI "after SQL"-tab...
I have tried them using a semi-column ';' and it didnot work...

Eg:
Update;
Update

I would like to avoid writing BTEQ script just for this purpose...

Your feedback is highly appreciated...

We are using DS to do this... Job Flow is something like this HashFile, Transform, SeqFile, OraBulk(DB) In the Transform we use a parameter(parmStartRow) on the constraint (link), which say only pick records from Hash where @INROWNUMBER>parmStartRow So initialy parmStartRow=0, When the job fails say...

We are planning to use Oracle Bulk Load stage to do a bulk load(not manual load)... What we intend to do is to re-start the bulk from where it left-off... Eg: Say we have 100,000 rows to load commit freqency = 10,000 While bulk load, it committed 5 times (50,000) and failed on the 6th time commit......

True...it is one physical hash-file...why did Ascential provide an option to have both reference link and normal link to hashfile stage??? Do you think there was a reason for that??? All I am trying to do is not cacheing the hashfile...just doing lookup and updating it...its a trade-off to write eac...

Thank You... I have tried it and it works fine with different hash-files(as in ur picture)... but i was looking to do it using one hashfile(same one)... it wil make it easy as i will have many lookups(links) and many update(links) from the transformer depending on the link-contraint. And that was wh...

I know the thing I am doing is basic...but its usefull to do the flow design...I am not able to post the pic of the job... HEre is what i am trying to do... input----> Transform(lookup/update hashfile) ---->output ^ | | | (lookup)| |(not a dotted line) | |(update hash) | V HashFile PS: Tried to make...

Ken, Thank You for the reply... I tried doing it and it gives "cyclic or linear dependencies" error on the transformer. I need to keep the hash-file uptodate to make sure the next record processed does a lookup on the updated hashfile(not to miss the lookup for record which is already proc...

Ken, Thank You for the reply...
I tried doing it and it gives "cyclic or linear dependencies" error on the transformer.

Can we have lookup & update of the same hashfile from the same transformer.

From a transformer I have to "lookup" a hashfile and also "update" the same hash if its not there in the hashfile(have one dashed-link for lookup & one link for update to hashfile)

Ray, I want output file to look something like this.. output file: (field3, concatenation(field1)) 100871,"4.8" 100890,"5854" 100860,"353230" 100861,"4542" Presently I am getting: output file: (field3, concatenation(field1)) 100871,"4.8" 100890,"...

Thanks Ray for pointing out that... I have tried out the method suggested for this...i am able to get the results in a single row, BUT have a small problem of writting the output. input file: 4.8,"1985-01-01",100871,3.2,"1985-12-31" 58,"1985-01-01",100890,46.4,"&qu...

Can I use COLUMN EXPORT STAGE to do the flattenning part(vertical pivoting) of the data???

Can we use any of the other Restructure stages available in PX 7x?

Is there other way to do it without using the concatenation of fields suggested....

Please give you feedback ASAP....its URGENT!!!

Ray, Sorry, If you found me using all upper-case as me shouting...that was not my intention...just wanted to get some expert feedback on the topic. Teej, I guess when you said that there is a new stage in PX which can be used for surrogate keys, i think its the Column-Generator stage which has some ...

We are using PX 7.x...the latest version. Can you please tell me where you have got the info that they have a NEW stage in PX to generate Surrogate Keys? ALSO, IS THERE A WAY WE CAN RUN 'DEBUGGER' WHEN DOING PX-JOBS???...SO THAT I CAN TRACE THE JOB. AS RAY SAID, WE CAN USE PEEK TO CHECK THE DATA...B...