DSXchange

Thanks team. I have reset the ORACLE LOAD OPTIONS, with DIRECT=FALSE, then it worked out.

Changed the node as 1 and executed. Again same problem.

hi, I am extracting data from the pipe delimter file which consists of nullable columns. I have assigned null field value as " " in the format properties and set $APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL = 1. But still I am receiving "import error and no default value" and the rec...

Hi, I am facing performance issue in loading data from sequentail file to partitioned table (Oracle EE stage) . The same file while loading through SQLLDR finishes in 1 min but takes 45 min when loading through datastage. No of records in file: 350 There is no indexes in the target table and constra...

I have changed the transformer with IPC stage. I faced the same problem.

It seems there is some problem in the Active stages in accepting the input records.

Yes. Both are different.

Even I have changed the link names and dropped the transformer and recreated it.

Hi,

I am also facing the same problem.

I have splitted the job into 2 using Seq File Stage.

Job1

Oracle Stage -> Seq

Job2

Seq -> Transformer -> Seq

Job1 executes successfully.

But in Job2, records were not fetched from the Seq file and the job keeps on running.

Thanks

Vinod

Hi Narasimha,

Could you please provide me HFC application.
My mail id is

vinod2scope@yahoo.com

Thanks

Vinod

Hi,

I want convert datatypes inside the transformer.
Any soluton.

Thanks

Vinod

Hi,

I am using table lookups using two keys. The lookup get failed
showing the below mentioned description.

LU failure found on link Lookup_Warehouse for InputKey 41168|2004

Thanks

Vinod

Hi,

seperate the table based on keys

for eg: if the table consists of 10 county data, split it into 10 based on country, giving country as a job parameter.

Give the county code as multiple instance, shedule it in such a way so that it runs parallelly.

Vinod

Thanks Craig.

Even though I have not mentioned as key, I am facing the same issue.

Thanks

Vinod

hi Creig, For eg: input item_no, week_id, version1,version2,version3,version4,version5 output item_no, week_id, version 1 1 version1 2 2 version2 3 3 version3 4 4 version4 5 5 version5 here after pivot stage , I am getting 4 duplicates excluding the first one. Then the value of 4 duplicates were nul...

Hi,

I am facing duplicates once the data crosses the pivot stage. Is there any solution to prevent in pivot stage itself.

Thanks

Vinod

Kumar,

I can't see the process ID in unix, but I can see them in director cleanup resource window mentioning that process Id is unavailable.