DSXchange

Hi I guess In the transformer, left pane bottom put the datatype of the source and in the right pane bottom put the datatype of the target Now in the drag and drop canvas right click on the derivation part, u can see the type conversion functions and which ever conversion u want u can go ahead this ...

Hi I guess the source records r not matching with look-up and can I know y did opted for sparse look-up(Is the look-up data volume very high) check with 1 or 2 matching records from the source then u should not get this warning Hi, Please help me fix this warning Lookup_1,0: Input record has no look...

Hi Sanjay,
Where will I find this option
thanks

sanjay wrote:Hi

increase VALUE APT_PM_NODE_TIMEOUT TO AROUND 600 - 800


Sanjay

Hi Sanjay,
Where will I find this option
thanks

sanjay wrote:Hi

increase VALUE APT_PM_NODE_TIMEOUT TO AROUND 600 - 800


Sanjay

Hi I was trying to insert the records from file to oracle table but In my previous experience when Ever I want to insert I used to opt for Upsert(udate and Insert) I used to give the condition in update as 1=2 ie update can never happen as 1 can never be equal to 2 so this is how I inserted records ...

Hi I am happy to see the option "OPEN" as mentioned but with write mode as upsert, I could not see that option when I am trying to use write mode as "LOAD" I am getting an error Could you please suggest me a method only with Upsert write method (where I will use only insert condi...

Could anyone elaborate on this

thanks
suresh

I have a target table say EMP table I have to load 1000 records from a file into EMP table and say all the 1000 records coming from file have only the Dept no's 1,2,3 When my job runs, my criteria is to delete all the existing records in the table with dept no 1,2,3 and load the fresh 1000 records i...

Hi always
sort the data before it is sent to aggregator

so that sll the data belonging to one particular group
will go to one chunk and hence grouping at aggr stage will become faster

thanks
suresh

ArndW wrote:pre-sort the incoming data and tell the aggravator about it. ...

Hi In the transformer u can use the string function called ltrim and apply that on this column may solve ur problem pls ack me Hi, I have a numeric column in the backend. values for this looks like below : 00000123 00000456 00000789 in datastage I need to trim to look like below: 123 456 789 can som...

Hi In the transformer u can use the string function called ltrim and apply that on this column may solve ur problem pls ack me Hi, I have a numeric column in the backend. values for this looks like below : 00000123 00000456 00000789 in datastage I need to trim to look like below: 123 456 789 can som...