DSXchange

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...

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...

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...

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 ...

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...

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...

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...

The Usage Analysis tool, when run on a table definition, is as close as you'll get to an impact analysis. However, proper functioning of this hinges upon proper management of metadata in jobs - never breaking the link between the job and the table definition(s) loaded into it. Thanks Ray & Rob....

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.

kalpna wrote:Hi! Poorna
I was refering to
Xml input-->Output Tab-->Columns-->Description
There you have your xml path defined for each column.

Kalpna

Thanks Kalpna.

That worked.

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

Hi 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

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...

Thanks Chulett, that helps.

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.

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...