DSXchange

Why not give the Oracle Bulk Load stage a try? Pretty easy to use in 'Automatic' mode. ... what is the service name i am using oraoci bulk stage. I am getting some this kind of error OraBulkTest1..Oracle_OCI_Load_17: ORA-12514: TNS:listener does not currently know of service requested in connect de...

Hi I haven't worked in server jobs and also in oracle. I am having a 2GB file i need to load it to oracle table that to fastly. I tried with oracle oci stage but it is taking very long time hours and hours its running. could any one help me out to save the time might be through any stage or any scri...

CC_delta is the change capture stage name. "In the input tab of your Change Capture stage you have used the same partition on the same partition keys. Also your sorting keys are the same and in the same order." yeah its the same.

Hi My source is datastage and teradata enterprise stage. From teradata a link is taken to copy stage and then from copy to change capture. Dataset linked with change capture. from copy stage one link is taken to merge stage and from change capture output link is taken to merge and from merge to outp...

sorry guys i got it, its due to the version.

Hi all I am using windows XP and i have installed datastage 7.5.1A. In this server jobs are working fine but when i am trying to build a job and execute it. its giving me error "This jobtype is not currently runnable on this platform". but the highlight is i have used a teradata enterprise...

how to sort data inside teradata when it is a source and i have only the output tab where no partitioning tab is available, when it is in target we can see the input tab and partitioning tab where we can perform a sort.kindly do reply.. You will have to give a suitable Order By clause in the SQL qu...

how to sort data inside teradata when it is a source and i have only the output tab where no partitioning tab is available, when it is in target we can see the input tab and partitioning tab where we can perform a sort.kindly do reply..[/quote] You will have to give a suitable Order By clause in th...

Hi all, I want to know how to export the information in the log to a file.can anybody help me out in ths.......... Thanks in Advance........ Regards, skumar. try this dsjob -logdetail ProjectName JobName 'dsjob -logsum ProjectName JobName|head -1|awk '{print $1}'` `dsjob -logsum ProjectName JobName...

Have youy tried sorting the data inside Teradata? Try sorting the data inside Terradata feed this to a Sort stage and set the option inside to Don't Sort and then try it out. Regards The Bird how to sort data inside teradata when it is a source and i have only the output tab where no partitioning t...

try what salil suggested if that doesnt help u try with a look up stage . I tried but it dosent work,i also tried with a sort stage,i changed the partitioning to "set" in both the teradata stage and the first join stage and in the second join stage i made the partition to propogate and i ...

Can u tell us the average size of ur single record when it reaches the aggregator? Any idea about the system memory? Are the inputs partitioned in each stage? How many nodes specified in parameter file? at the source level itself its stoping after the 66th million record just moving to join when i ...

Hello, I am using two teradata stage and i am doing a inner join then again i am doing a left outer join with a dataset,then i am doing a look up with a dataset the lookup condition is continue,then i am doing some transformation work in transformer and then doing some aggregation then finally putti...

ray.wurlod wrote:

kalimuddin wrote:can any one help me in resolving it.

Not all of us are in your time zone. Some of us need to sleep. Have you searched the forum for all terms "Oracle" and "NLS"?

ya I do understand, i am searching and i am performing those steps also.

Hello

I am creating a job which makes all the other jobs to run. I know in routine with the help of jobcontrol.h i can do. But i want to know that in buildop is it possible to call the jobcontrol.h, if yes please provide me a solution how to do it.

Thanks & Regards,
Kalimuddin.