DSXchange

Hi That is quite natural, we can do 1. Filter the data (Constraint) 2. Do conversions 3. We can create Surrogate Key So many things we have to do. That is why performance is low. Filter stage is specified only for that purpose http://it.toolbox.com/blogs/infosphere/is-the-datastage-parallel-transfor...

Hi


Go through this like you can found many date conversions.




http://mike2.openmethodology.org/wiki/A ... ming_Guide

iamnagus wrote:How Many types of syntaxes available for date conversions in MODIFY stage.

can any one brief about this

ABC123 After selecting the data, usually we are checking database connection; column definition of metadata is matching with base table. All these happened Oracle, ODBC, Sequential File stage except Hash File As per my knowledge a copy of Table Definition (Meta Data) is holding in Stage level. When ...

Rakesh You can get more information when you read Datastage Advanced developer guide. Hi all, I am running a job with source as MQ and target as teradata, between many transformations/business rules has been implemented. My question is, what are the parameters will affects the performance of the job...

Hi


Good question, I tried with Oracle stage it creates 2 instances every time.
More over mostly it differs based on Stage.


I am not sure.

DWH-M wrote:HI

In px job if i am using 5 stages in job and running on 3 node configfile, howmany instances data stage will create backend.


thanx in advance

SD

Shave After reading i understand you can view your data present Varchar data type. All your source CSV data is in Integer or number right. Try to cover all your source column data types in to as per the Target types and try to view the data. My target is DB2 database. But I am trying to load it usin...

Akonda Are you going to give this data as input some one in your environment? If that is the reason you have to check with them. Other wise it is performance issue to your system. Usually this discussion is not good in DSXchange, but this also part of our work. Thanks to Hulett he has given TOAD gro...

Akonda Are you going to give this data as input some one in your environment? If that is the reason you have to check with them. Other wise it is performance issue to your system. Usually this discussion is not good in DSXchange, but this also part of our work. Hi I am getting below error while expr...

Veera Posted by Vincent McBurney Go to the home directory of your project and have a look at th rights and ownership of the RT_CONFIG1809 folder. Is i different to the other RT_CONFIG folders? Have a look insid that folder and make sure there are two files there. Hash file are made up of two files. ...

Hi Operators. These underlie the stages in a DataStage job. A single stage may correspond to a single operator, or a number of operators, depending on the properties you have set, and whether you have chosen to partition or collect or sort data on the input link to a stage. At compilation, DataStage...

Skumar

SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL '@RECORD' LIKE '%Job_Name%'


Take Usage Analysis at Manager.



These two I know.

Haisen


As per my knowledge PL/SQL is the only option to do all three in one jobs.

haisen wrote:Yes, is there a way to do insert, update & delete all in a single job?

Aladap12 This is not Datastage issue, you have to write a SQL query to remove duplicates at Source Database Stage ( userdefined ). DELETE FROM table_name A WHERE a.rowid > ANY (SELECT B.rowid FROM table_name B WHERE A.col1 = B.col1 AND A.col2 = B.col2 ); ---------------------------------------------...

MattKeevil Go through your BRD, discuss with your BA/Team Lead. They have to clarify all your droughts. Then start with TDD. In TDD you have given complete flow of mapping (column level) Transformation Rules based on Business logic, Pseudocode, description purpose of this job. Check with your team i...

Horserider Your entire questions are reasonable manner (1) Transformer usage that depends on business logic, In PX we have individual stage for transformations that is why Transformer usage is less. (2) Lookup stage earlier in server 16 per one transformer, i am not sure. (3) For Merge, Join and Loo...