DSXchange

hi Dinthat,

Open up an cursor in your PL/SQL procedure to loop through each record and commit based on your insert / update DML statement execution status.

Thanks & regards
Sudhindra P S

hi, You could make use of External Source stage to invoke OS scripts which uses Datastage API to trigger an ETL job. Now you could use this external source stage in your parallel job canvas. This master job which invokes other Datastage jobs are called as Wrapper jobs. Thanks & regards Sudhindra...

hi, You could make use of External Source stage to invoke OS scripts which uses Datastage API to trigger an ETL job. Now you could use this external source stage in your parallel job canvas. This master job which invokes other Datastage jobs are called as Wrapper jobs. Thanks & regards Sudhindra...

hi,

If you are sure that input column is of "Timestamp" data type then you could make use of TimeStamp to string conversion function in Transformer stage or Modifier stage.
Ex: TimestampToString(InputColumn,"%yyyy%mm%dd")

Thanks & regards
Sudhindra P S

hi divine, Design your ETL job in the following way. Source System --> Join Stage -->TransformerStage -->FilterStage -->Target System. (1) Perform "Innerjoin/LeftOuter Join(As per your need)" on "Source input stream" and "reference stream" using join stage based on your...

hi dinthat, We had a similar issue a while ago. We raised an ecase with IBM but couldn't get proper solution from them in time. And moreover we didn't had enough time to wait for the solution from their end we just went with implementing PL/SQL SP to perform the task. The problem here is, Datastage ...

hi, If you were using Datastage Ver8.0.1 then you could have made use of "Range Lookup" functionality. Otherwise, you need to do this conventional way. i.e. in the Transformer stage using stage variables you need to loop through and find whether "Reporting Date" falls between &qu...

hi, Just open up any of the job log you have run, from Datastage director. And see "Environmental Variable Settings" info, where you would see all environmental variables being exported to run your ETL job. In that list try to find these two variable values "LOGIN" and "LOGN...

hi Ray,

iconv command comes with UNIX. Please see documentation for the same in the below mentioned link.
http://www.gnu.org/software/libiconv/do ... onv.1.html

Thanks & regards
Sudhindra P S

hi,

You could do this in Unix by using iconv function. The syntax for which is as below.
iconv -f <FromSourceCodePage> -t <ToTargetCodePage> <FileNameTobeConverted.txt> > <DestinationFileName>

Thanks & regards
Sudhindra P S

hi, You could determine NLS settings on your Oracle DB by executing below SQL query. SELECT * FROM NLS_SESSION_PARAMETERS; Just try inserting the character you are talking about in the DB as an first step. If it is fine then check whether code page on your ETL OS is same as that you see in DB. If no...

hi, If one has good amount of experince in Informatica, he could apply the same concepts in Datastage too. As Datastage has various stages(Transformations) in it which can support any complex logic to be applied. The basic criteria to work with any ETL tool, one need to have solid understanding of O...

hi,

You could create a dummy column in all of your 5 datasets output link by using column genrator stage or Transformer stage and then merge data using this Dummy column as key column.

Thanks & regards
Sudhindra P S

hi, You could achieve this by designing an Shared container job. But it all depends on your metadata you are processing on a job by job basis. It purely depends up on your business requirement and job design. The types of validations you have mentioned in your questionairre can be handled quite easi...

hi,

You can write insert statements for both insert query placeholder as well as for update query place holder. This ensures you are not updating anything out there. As both SQL statements are of insert DML statements.

Thanks & regards
Sudhindra P S