Search found 188 matches
- Thu Mar 30, 2006 3:45 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Import Table Definitions
- Replies: 4
- Views: 1156
Is there a way we can define a generic ODBC connection for different Databases on the same server, so that we can import table definitions for all the tables in all databases on that Server, using the same DSN? Hi Poorna, I don't think that is ever possible unless all databases have same drivers. T...
- Thu Mar 30, 2006 9:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Import Table Definitions
- Replies: 4
- Views: 1156
Import Table Definitions
We are trying to import TableDefintions from the Manager -ImportTableDefinitions -ODBC TableDefinitions. If we are trying to import the TableDefinitions from the default Database defined for the ODBC connection(DSN), it works fine. If we try to import the TableDefinitions from the different Database...
- Fri Mar 17, 2006 2:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Derivation in ODBC Stage
- Replies: 4
- Views: 1236
The derivation is used when Auto-generated SQL is chosen. If a column's derivation is blank, then the column name is used. The derivation is always the metadata name dot column name. Therefore, the metadata name must be either schema dot tablename or just tablename in order for the Auto-generated S...
- Fri Mar 17, 2006 12:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Derivation in ODBC Stage
- Replies: 4
- Views: 1236
You can put anything in the Derivation field that you might put in a column specification in the SELECT clause, including SQL expressions, aggregate functions, and so on. Try it. Maybe something like col1 || ' -- ' || col2 or max(col4) or even DISTINCT col5 . You can add GROUP BY, HAVING and ORDER ...
- Fri Mar 17, 2006 8:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Derivation in ODBC Stage
- Replies: 4
- Views: 1236
Derivation in ODBC Stage
What is the use of the Derivation field in ODBC Stage( Outputs - Columns - Derivation )? I know jobs work even with out Derivation field. Are there any specific advantages for keeping the Derivation field? Are there any disadvantages for not keeping the Derivation field? We also observed that when a...
- Mon Mar 06, 2006 12:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Impact Analysis on Columns
- Replies: 7
- Views: 2730
My List all files and tables used by jobs in a dsx file tool can help you identify impacts at a file and table level. Since it works with a dsx file, it does not require that you followed best practices with your metadata repository. You will find it on the DataStage Tools page of www.anotheritco.c...
- Fri Mar 03, 2006 3:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: substring
- Replies: 7
- Views: 3171
substring
Hi All, I would like to extract specific substring from string, without knowing the position of that substring. That particular substring position is not fixed, it can be any where in the String. Example :This Job Extracts New Employment Data for the Processing month Based on Current Month File I wo...
- Fri Mar 03, 2006 10:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Impact Analysis on Columns
- Replies: 7
- Views: 2730
- Fri Mar 03, 2006 8:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Impact Analysis on Columns
- Replies: 7
- Views: 2730
Impact Analysis on Columns
Hi All,
Is it possible to do an ImpactAnalysis on Columns,
without using MetaStage tool.
I tried using "SearchDSX" job from DeveloperNet, looks like its not working.
Any thoughts?
Thanks in Advance.
Is it possible to do an ImpactAnalysis on Columns,
without using MetaStage tool.
I tried using "SearchDSX" job from DeveloperNet, looks like its not working.
Any thoughts?
Thanks in Advance.
- Thu Feb 16, 2006 11:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML Issue
- Replies: 4
- Views: 1412
- Thu Feb 16, 2006 10:40 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML Issue
- Replies: 4
- Views: 1412
Hi Kalpna,kalpna wrote:Hi! Poorna
in your Xml path definition(in xml input stage) make sure that, you also enter text()
I.e:......../../../Organization/text()
Kalpna
In the XML InputStage-XML source,
i don't see that option.
i only see XMLSource column
Column content :XMLdocument or URL/FilePath
Thanks
- Thu Feb 16, 2006 10:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML Issue
- Replies: 4
- Views: 1412
XML Issue
Hi All, I haven't dealt with XML files before. I have a simple XML file and trying to convert to falt file (.TXT file). I used FolderStage --->XMLInput ---->SequentialFile . I am getting output like this: <OrganizationID>10412</OrganizationID><ClubID>12320</ClubID> <OrganizationID>10413</Organizatio...
- Wed Feb 15, 2006 1:22 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generate Dates between 2 Dates
- Replies: 3
- Views: 1288
- Wed Feb 15, 2006 8:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generate Dates between 2 Dates
- Replies: 3
- Views: 1288
Generate Dates between 2 Dates
Hi All,
I have a requirement where i need to generate all the dates between 2 given dates.
I need to do a lookup against HolidaysList for that generated list and also need to exclude Saturdays & Sundays.
Any thoughts on how we can implement this?
Thanks in Advance.
I have a requirement where i need to generate all the dates between 2 given dates.
I need to do a lookup against HolidaysList for that generated list and also need to exclude Saturdays & Sundays.
Any thoughts on how we can implement this?
Thanks in Advance.
- Fri Feb 03, 2006 1:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance Issue
- Replies: 8
- Views: 2487
Is it 5 seconds to get the first row or the last row of data? Many people confuse the quick response of the first found rows as the indication the entire process takes a short time. Try using an ORDER BY in your SQL query tool to cause all rows to be computed first and see if the time changes. Than...