DSXchange

Yes, The COLUMN ORDER needs to be the same too.

OK..I will give it a try with EVERYTHING IDENTICAL

Thanks All

Well, the answer to my question is both YES & NO from different people.

I think as far as the COLUMN NAMES and NUMBER (count) is same on both input links, it should be fine. The order may Vary.

I am getting an issue with this in the result and hence I am posting this query

What do mean same order of columns but not order of links?

I am using SORT/MERGE in the stage.
My question is does the ORDER of cols need be the same on both input links?
Pls see example

What do mean same order of columns but not order of links?

I am using SORT/MERGE in the stage.
My question is does the ORDER of cols need be the same on both input links?
Pls see example

Hi, When we use 2 input links to a Link Collector stage, is it necessary to have the same name & total number of cols and also the same ORDERING of cols or if all the column names ( & number) are same in both INPUT links but the ordering is different it will still work correctly? e.g INPUT 1...

Hi All, I working on a ETl job Source is Oracle Table Target is Flat file I need to create a process for delta load. I have control table which will have Maxdate , Control table is on Sqlserver . Can some help me how to extract delta records from the source which has the Last_update_date column. Tha...

Hi,

As Datastage has a plug_in for MQSeries, similarly does it have one for MSMQ?
Is there a way to talk to MSMQ from datatsage?
Basically we want the DS job to be triggered when a message arrives in MSMQ and then transform the message in a particular format.

Thanks,
NV

Hi All, I want to know how to automate the datastage jobs on Windows environment. Right now we don't have any scheduling tool and we are implementing the Datastage first time. If datastage scheduling is not flexible please let me know which scheduling tools we can use for datastage jobs on windows e...

I'm trying to create the Environment variable in Datastage Adminstrator.
I'm getting the below error.
DSR.ADMIN: Failed to write to project file.

Please let me know what to do to create the Environment variables.

Thanks in Advance

Thanks ray,

I did the same when i was working on this kind of stuff yesterday. But just wanted to confirm :D . Can we use an external target stage and direct the output to the Unix blackhole (>> Null)?

I think there is some confusion here..I hope this clarifies.. what I meant by FIX format is The Financial Information eXchange <http://en.wikipedia.org/wiki/FIX_protocol> (FIX) protocol is a messaging standard developed specifically for the real-time electronic exchange of securities transactions. F...

Hi,

Can we create/read "FIX" format messages uisng ETL.
We have a requirement where we have to convert .csv files into a FIX format to be fed to a FIX Engine.

Any info on this front would be great.

Regards,
NV

I will be creating a job which will run every 15 min. Can someone please let me the best approaches in below secnarios? 1. I want to know if my job runs more then 15 min then how I can handle the next cycle. 2. If my job fails how can I restart from where it got failed. Eg.. if my job is loading a t...

Hi , I am getting the error like below when I run the job. APT_CombinedOperatorController(1),0: Caught unknown exception from runLocally(). I am doing validations and comparing of values for updation in the job. I verrified all the stage variables specified in the transformer stage. please help me o...