DSXchange

Yes Ray, we did that

Thanks again, I did try out with Cast , but with the ODBC connector was having no luck. we used the Oracle connector to Load to Oracle , TD connector for Teradata (as earlier) and ran the job, ran absolutely fine. (The only reason we were not using it initially because we were not able to test conne...

Thank you for your response. The metadata was imported through designer , Import --Table Definitions --Start connector Import Wizard . Im not really sure how to do it otherwise, i'll look up that up, can you give me a headsup where I can read about it. I'll also definately read through on WCHAR , so...

Hi. Some help needed for a test job on an NLS install. There is a column being imported from Teradata To Oracle. Currently all, we are doing is using a TD connector to extract from Teradata and an ODBC connector (Oracle connector isnt working, that's another issue though) to load to Oracle. The sour...

Thanks Ray. Appreciate the heads up.

Is there a limitation to the number of columns (not rows) that a DataStage job can extract and consequently load? Some more info - There is a requirement that has come in from a new area of business. They want a table in the EDW that would have a very large number of cols, say 900. The ETL team has ...

Thank you Ray for the input, will try this.

We've modified the query at source currently but will try this as well.

Sorry, here is more info. The First column is activity number , the second col is week number , the date cols are end.date and start.date.... This is how ideally the data should look like F.no||w.No||e.date||s.date|| 1 || 234||Oct 4th||0|| The current data looks like F.no||w.No||e.date||s.date|| 1 |...

Gurus, here is something that I need your help on I have two cols - F.No and W.No (Both of Datatype Integer), and two date cols , s.date and e.date ||F.No||W.NO||e.date||s.date|| F.no - is supposed to have only one W.no associated with it, and only either of s.date or e.date associated with it. Curr...

some more details, which might paint a better picture of the scenario..... The jobs are scheduled through mainframe jobs which invoke a perl script wrapper which triggers the DataStage sequences. The above check should be done in the first sequence. If it registers positive then go through the seque...

Thank you Vincent And Craig.. Vincent, I'm going to try for the script or use the SQL plus commands and get back (with more questions I guess :) ). Though how does one make use of that o/p......... i.e once you have confirmed for zero records , how do you guide the flow? Craig, I've been trying to s...

Hi, We need to extract records to a dataset from SQL server, on an everyday basis. There is a high possiblity that 0 records would be retrieved on a few days. If that is the case the job/seq shouldnt go ahead but exit gracefully. The check shouldnt be done when we are loading the data, it should be ...

When you are asked to estimate a timeframe over how long a particular bit of DataStage job would take, it does depend on how complex the job is, what sort of transformations etc are required, are there any other dependencies like writting scripts etc etc But my question is there a document which exp...