Search found 26 matches
- Mon Dec 13, 2010 11:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Transformation rule
- Replies: 1
- Views: 1297
Transformation rule
how to implement Insert,Update or Delete logic in datastage?
- Tue Nov 23, 2010 12:49 am
- Forum: General
- Topic: Project Estimation
- Replies: 1
- Views: 1599
Project Estimation
What is Project Estimation?
What are the steps involved in project estimation..?
Please kindly clarify my doubt.
What are the steps involved in project estimation..?
Please kindly clarify my doubt.
- Fri Sep 10, 2010 4:02 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to implement in datastage?
- Replies: 5
- Views: 3369
how to implement in datastage?
The below rule how to implement in datastage? Transform record as per INSERT process type. Lookup Acct where EXPY_date = 'yyy/mm/dd' IF not found THEN INSERT record ELSEIF any of DELTA VALUE columns has changed THEN UPDATE record as per UPDATE process type INSERT record ELSE Perform UPDATE CLOSE ENDIF
- Wed Sep 08, 2010 11:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Routines in Datastage?
- Replies: 1
- Views: 1771
Routines in Datastage?
In how many possible ways can call routines in datastage?
- Wed Sep 08, 2010 6:29 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Routine
- Replies: 2
- Views: 1871
Routine
How to call routine in datastage?
one more is
how many possible ways can call routine in datastage?
one more is
how many possible ways can call routine in datastage?
- Wed Sep 08, 2010 12:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Initial Load in Datastage?
- Replies: 1
- Views: 1925
Initial Load in Datastage?
what is meant by Initial Load & Delta Load..?
when does it come into picture in Datastage ?
when does it come into picture in Datastage ?
- Mon Sep 06, 2010 12:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Linked sort?
- Replies: 2
- Views: 1496
Linked sort?
what is meant by linked sort..?
any diff b/w sort & linked sort....?
any diff b/w sort & linked sort....?
- Fri Sep 03, 2010 4:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Dataset
- Replies: 13
- Views: 7065
Dataset
while loading dataset how many files are created internally?
and what is default path of dataset ...?
and what is default path of dataset ...?
- Fri Sep 03, 2010 3:00 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Configuration file
- Replies: 3
- Views: 2765
Configuration file
any body tell me the path of configuration in datastage..?
- Wed Sep 01, 2010 2:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job has been aborted after some rows..?
- Replies: 4
- Views: 2528
Job has been aborted after some rows..?
I have a datastage job which is having 900 records.
my qst is the job has been aborted after 400 records. i want to start from 401 record ?
how to do that..?
_________________
my qst is the job has been aborted after 400 records. i want to start from 401 record ?
how to do that..?
_________________
- Tue Aug 31, 2010 3:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Interview qst?(Lookup table)
- Replies: 2
- Views: 2685
Interview qst?(Lookup table)
I have 100 records in source and 20 matching records in refernce table.
how many records did u get in target?
how many records did u get in target?
- Tue Aug 31, 2010 2:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job has to start after N records..?
- Replies: 4
- Views: 3314
Job has to start after N records..?
I have datastage job which is having 1000 records.my qst is
my job is aborted is after 500 records. iwant to start from 501 record.
how can u achieve using transformer stage..?
my job is aborted is after 500 records. iwant to start from 501 record.
how can u achieve using transformer stage..?
- Mon Aug 30, 2010 3:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to validate date function in datastage?
- Replies: 2
- Views: 9497
how to validate date function in datastage?
how to implement the below rule in Datastage?
i have a column "TransDate" the datatype is char and format is yyyymmdd
yyyy should be start with "20"
mm shd be value 01 through 12.
i have a column "TransDate" the datatype is char and format is yyyymmdd
yyyy should be start with "20"
mm shd be value 01 through 12.
- Mon Aug 30, 2010 3:19 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date function
- Replies: 2
- Views: 1979
Date function
how to implement the below rule in Datastage?
i have a column "TransDate" (yyyymmdd)
yyyy should be start with "20"
mm shd be value 01 through 12.
i have a column "TransDate" (yyyymmdd)
yyyy should be start with "20"
mm shd be value 01 through 12.
- Sun Jul 25, 2010 10:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how to remove duplicates in transformer stage..?
- Replies: 6
- Views: 6096
how to remove duplicates in transformer stage..?
Please provide solution for above query?