DSXchange

use unix command orachadmin datasetname

Hi :lol: may i know ur real concern , is this? that is everytime invocation id is changing and how can we manually give evrytime invocation id ,we wanna automatically i take this is my solution from my end just add parameter and give parameter name in job activity and before this value assign in job...

Hi
You just add column generator to target database and add these two columns and give some meaning full data for columns and proceed for further process

:lol: hi auto is a default partiioning method when we select auto it dont allow to select key for sort at link level or unique etc, conclusion is what ever we had given in keys place in sort stage then it sorts based on that key or keys, here one doubt when we select column1 as sort key and in part...

:lol: Hi First import from sequential file definitions,at the time of importing select first line is column names and import into datastage, then in the sequential file , as u already done select firstline is column names and import the table definitions at columns tab, now the point here is you don...

Hi Enter the correct format in sequential file as u said that all records are loaded but in logs it is saying that one record is rejected, this is because, at the end of file they entered one empty line , so all records are loaded into the target and one line is not loaded because of not finding any...

if that is local then '#parameter#'

:D Hi Sir, you first check the following steps 1.columns selected at user defined query and at columns tab must be equal. 2.according to your error it is not accepting the parameter value in Where clause.so first check whether it is project level parameter or job level 2.1.if project level, then use...

:lol: Hi We have so many sources sqlserver, oracle, db2, informix ..etc initially we have OCI stage, with this stage we will connect up to particular databases, for example older datastage versions can not connect to oracle 10g, because at that time that verison of oracle is not developed, so with O...

:) Hi, Nice answer for analysing partitions use APT_DUMP_SCORE but from my side i had one solution, i also faced this problem but in my situation the job gave warnings and as well as it is aborted, my case is i use one 'sort stage' then 'remove duplicate stage' but the keys in two stages are not sam...

When i am trying to delete it is giving error message like (SOURCE OBJECT CANOT FOUND IN REPOSITORY )ANY body can help the same : :) Go to Datastage Administrator and in projects tab we have one option ClenUp click that option and it will deletes all the contents of the repository, but the project ...

Based on your sentences i can say one thing based on my understanding step1: from query you are fetching constant column dummy which always contain the value as '1' What you are missing is that the dummy column is coming from the right hand side of a left outer join. So when no match is found, this...

XML (extensible markup language) is a way of encapsulate metadata (in the form of tags) with data. DataStage can read and write XML via specific stages (XML Input and XML output). ... Your post help me in updating some knowledge, but can u please give me clarity about in any where we are using XML ...

Hello all, I am facing a problem with Join stage. I do have two input links, being joined in left outer join mode. Subsequent to Join stage, there is a transformer implementing the logic to detect unmatched records, and place them in a file. In the records matched, they move on in the job flow. To ...