Search found 55 matches
- Tue Apr 11, 2017 11:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector Bulk Load Issue
- Replies: 5
- Views: 3752
- Fri Apr 07, 2017 5:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata Connector Bulk Load Issue
- Replies: 5
- Views: 3752
Teradata Connector Bulk Load Issue
Hi, Please find the simple design. Oracle connector--->Teradata Connector I am reading oracle table data which is very huge like say 10 million data into the Teradata using Bulk mode to process the data within seconds. With Immediate mode the above job ran for 4 hours. So went for Bulk mode Details:...
- Wed Dec 02, 2015 11:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue in capturing string by positions in transformer stage
- Replies: 2
- Views: 2493
Issue in capturing string by positions in transformer stage
Hi, I have a requirement while loading the file. The below file is semicolon delimiter & Double quote for character fields. I/p: 1000;12-11-2000;"";"ASDDIK";"R" 1001;12-12-2001;"";""TOMI"" ";"R" 1002;01-01-1982;"&quo...
- Sun Jun 07, 2015 4:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Rank and Priority in a Job
- Replies: 1
- Views: 1949
Rank and Priority in a Job
I have a Scenario: Input(text file): ID VALUE CODE 01 1000 DED 01 1000 DED 01 1000 DEP 01 1000 DEP 01 1000 INN 01 1000 INN 02 2000 INN 02 2000 DEP 02 2000 INN 02 2000 DEP 03 3000 INN 03 3000 INN 04 4000 DED 04 4000 DED Output(table): ID VALUE CODE 01 1000 DEP 02 2000 DEP 03 3000 INN 04 4000 DED Outp...
- Tue May 26, 2015 2:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup failing for partial matched records
- Replies: 5
- Views: 3733
- Mon May 25, 2015 4:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup failing for partial matched records
- Replies: 5
- Views: 3733
- Thu May 21, 2015 11:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup failing for partial matched records
- Replies: 5
- Views: 3733
- Thu May 21, 2015 3:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup failing for partial matched records
- Replies: 5
- Views: 3733
Lookup failing for partial matched records
My Job Design: ODBC CONNECTOR(B) | ODBC CONNECTOR(A)--->LOOKUP1---> MATCHED1 ODBC CONNECTOR(B) | | | UNMATCHED1 FUNNEL1 --->LOOKUP3--->ODBC CONNECTOR(C) | | | ODBC CONNECTOR(B)-->LOOKUP2--> MATCHED2 UNMATCHED3 | | UNMATCHED2 ----------->FUNNEL2--------> ODBC CONNECTOR(D) I have a columns in A table ...
- Thu May 21, 2015 12:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replacing multiple Strings in a Field without Routines
- Replies: 3
- Views: 3509
- Wed May 20, 2015 3:06 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Replacing multiple Strings in a Field without Routines
- Replies: 3
- Views: 3509
Replacing multiple Strings in a Field without Routines
My Job Design: Table(A)-->Transformer-->Table(B) Table A have column NIVA and its values are fsdidkg,kdikkd,joejut and i need to replace those values with G,F,F. fsdidkg = G kdikkd = F joejut = F I have used ereplace and convert functions but i could able to change only G or F, If i am using more er...
- Mon May 18, 2015 2:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Full outer join gives more output record count than inputs
- Replies: 1
- Views: 2589
Full outer join gives more output record count than inputs
B(table) | A(table)--->Transformer ---->Join Stage(fullouterJoin)------>Transformer -------> Matched | Unmatched from B(Tfm) Above is my job design: Table A contains 10 columns in which 5 columns combination gives a key column (ID). My 5 cols are numbers(Oracle DB) when imported the metadata is dec...
- Fri May 15, 2015 2:56 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with Match and non Matching from Join Stage
- Replies: 2
- Views: 2177
I have resubmitted the post and I hope it is able to understand, now i did a test job for the matched output and i am able to get the correct count(4710). How I did it is I have taken the unique constriant combination of Table A after transformer(after Join) I kept Sort and filter it with 1(cluster ...
- Thu May 14, 2015 3:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with Match and non Matching from Join Stage
- Replies: 2
- Views: 2177
Issue with Match and non Matching from Join Stage
Hi, I have a requirement as below B(table) | A(table)---Join Stage(fullouterJoin)-------------> Transformer ----------> Matched | | Unmatched from A(Tfm) Unmatched from B(Tfm) I have 10 cols in A in which 5 cols should be merged to create a key(ID). I have 6 cols in which 1 column is key(ID). I am g...
- Tue May 05, 2015 11:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data not loading to ODBC connector
- Replies: 6
- Views: 3978
- Wed Apr 29, 2015 3:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Data not loading to ODBC connector
- Replies: 6
- Views: 3978