DSXchange

I just want to create a simple routine that should run my Job,If the Job failed the error should be logged! Can any one help me out in solving my Problem. I tried writing routines through some examples.But it throws errors Here is the sample routine,,, Can anyone correct me where i am wrong!! Hjob1 ...

I am facing the problem only if i am using the path as C:\
If i give the path like C:\Foldername It works fine. Is there any thump rule that we should not the path as C:\ or D:\

Whenever i use a Folder stage to get the path of the source file i am
getting an error like
DSD.UVOpen Unable to open folder C:\.
DSD.UVOpen Unable to open folder C:\.|
Can any one tell me what is the reason for the same.

And one more thing When is it advisable to go for a folder stage?

I need a clarification about ODBC stages and ORACLE OCI stages. In ODBC stage we use the DSN name that we have created via ODBC connectivity.But in ORACLE OCI only if we give the service name it works fine.But still in the general tab of the OCI stage DAtabase source name only is given not the servi...

Hi ,
what is the purpose of Preserve Partioning Flag???
If Preserve Partioning flag is "SET"
Can I change the existing partitioning method which is different from the preceding stage.

Help me out!!!!

Hi,,Can any one tell me how to allocate space using Configuration File?
What is the format and how to use it. What are the parameters required for that?
Can u explain me in detail!

I am not very clear with system variables.What does @OUTROWNUM do? and why should make the hashing Algorithm as SEQ.NUM? "If you're using a UV stage to load the hashed file, you can create a hashed file with auto-incrementing key by customising the CREATE TABLE statement to include DEFAULT NEXT...

I am using a hash File to load data into the Target,Is there any way to load duplicate records into the target,For example I have EmpNAme and DOJ as my source column and i am making the EMPNAME as the Key and in the Hash File stage,automatically all the Duplicate records are removed! One thing is i ...

ThanX Sunny,,,But a Transformer Stage can also access BASIC transforms, routines and functions Right?? There is no much difference between both the stages.I have gone through Parallel Job developer guide,but i cudnt find any difference.I have not worked on it. So i cudnt come out with a conclusion. ...

ThanX A lot RAY!!! I have never used those Functions to solve Date Problems,,,It seems to be more easier.I solve most of the Date Problems with Transforms inside the Transformer stage.
The one i explained was the same,,,

Regards,
Suma

Ray,

Job Parameter works very well inside a Transform, We can Right click and get the Job Parameter.And this code works very well for me!!

if i am Wrong,Where Exactly!!!!

Hi,,,

Try this ,,It works Fine,,,
Here FILENAME is the Job Parameter,,,,

ALl the functions are self Explanatory,,, G
Left(DateYearFirstToODBCWithTime(Oconv(MONTH.FIRST(FILENAME),"D-YMD")),19)

Get back to me for any help :D

Regards,,

Mary Suma

Hi,

At present i am working in Datastage 7.1.
I need to know about Datastage parallel Extender.How should i install parallel Extender?Should i get a seperate licence for that?Or it comes with the same package? Help me

I have worked both in Informatica and Datastage,It can be done very easily in Datastage. Take emp_Det table as the source and emp_address table as the look up.In the transformer stage you connect the Emp_no of the Emp_det table with Empno of the Emp_address table.Make sure that the empno of the emp_...

What does the auto-commit in Transaction Handling tab of an ODBC stage do?Can i use Auto-Commit option to commit after loading every 50 records into my Oracle Database.I dont find any other option to specify the same!Can any one explain me how to proceed with this!