DSXchange

It's just on the job level and I have not moved the job anywhere either. Is there a reference I can see to make sure that I am following all the steps.

Thanks

I am having trouble adding rules to message handler. I am getting lot of warnings like "Dropping Fields....because of prior component..." from the funnel stage due to the fact that RCP is turned on in the job. Same warnings are thrown for different fields. I thought if we add one rule for ...

I am facing a weird issue in multiplying a decimal field. My input data is defiend as Decimal(17,5) and output is also defined as Decimal(17,5). Sample Input Values : 00000000171.38000 00000000371.63000 Output Values : 00000000000000171.38000 00000000000004459.56000 I have to multiple this with eith...

I believe the issue is comment statements in the Lookup SQL. When I removed them it worked...

Yes. SQL runs fine in SQL Server client tool.

I already have the 'Disable Operator Combination' as True.

Thanks

KWWilliams - Reason I thought the problem with RCP is that I have checked multiple times between the columns in the SQL and the columns defined in the columns tab in ODBC Connector and they look the same. Is there anything else I need to check ? Following is the SQL in the Stage. SELECT Table.Field1...

It's ODBC Connector stage used as a reference (sparse) lookup with Lookup stage, source is a seq file and output is going via copy stage to a funnel stage and then to some other stages downstream. I turned on the OSH_SCHEMA and did not find anything under OSH_SCRIPT which says that RCP is ON or any ...

I am having trouble disabling RCP in a lookup ODBC Connector stage in a job. I have disabled it in Project level and also in the job level/stage level but I keep getting the following error. lkp_1: Unable to determine association between statement parameters and table columns. The connector will not...

To make things little clear on what I am trying to do : What Kryton explained is what I am trying to do. I have all the columns in Seq file but I don't have some of those columns in shared container but I want them in my output sequential file along with the columns from shared container. Reson I a...

I don't want to create these columns in transformer by specifying value in the derivation rather I want them to get the values using RCP from the shared container's output. Basically I want to use the shared container but did not want whatever job uses that to have the same metadata. I understand th...

I have replaced the copy stage with transformer but I still get the same error on those fields I expected to flow using RCP...RCP is turned on in all stages inclusing shared container. Derivation for those columns are empty in the transformer. Any input is appreciated...

I am having trouble using RCP with shared container in a job. Error is : Error when checking operator: Could not find input field My job design is : SeqFile---->Shared Container----->Copy Stage----->SeqFile Shared container's output has say 10 columns but it's input has 20 columns and the remaining ...

AND works but the problem is if there are Null values in the field being cheked then we have to explicitly specify that where as in SQL it takes care of it implicitly.

Thanks to all...

I am trying to see if there is a way we can implement NOT IN logic in FILTER stage. I can use the 2nd method of doing it in the transformer but wondering what's wrong with the 1st one. Does filter stage not support NOT IN ? I understand that all the conditions won't be true for one record and thats ...

I have already tried that and it did not work...I remember in DataStage you have to use OR for NOT IN conditions...