DSXchange

We are starting with a new data migration project. In the meanwhile, I have been asked to create DSParam file.
I am not sure what exactly is the difference between DSParam and DSEnv file. Tried searching but didn't get anything worthwhile. Can anyone please help?

Hi,
I am trying to replicate an old code into my system. At one of the places an Oracle table is uisng Upsert mode. I tried googling out the meaning of Upsert mode but no where could I find a good explanation. Could anyone explain me with an example what an Upsert mode actually does?

Hi Ray,
There's no indexing in the table.
Right now, sample data I have has very low number of records so I am not able to find out any difference in time by both the methods.
But in production, there would be huge amount of data and that's why I want to know which one would work better?

Hi,
I have data in a source table. I want to group the data based on a field.
Should I use SQL query inside my source table stage or shall I use an agreegator stage. Which one is a better option and why?

Thanks in advance .

Thanks for your quick responses. Things look more clear now.

Hi,
Can you please elaborate a bit?
I have heard that number of readers per node can be set only for fixed length files.
Also, please elaborate the first option you have specified.

I am reading a single sequential file from a single parallel job.

Hi,
I have a single sequential file which I want to read in parallel. How can I achieve that? I went through multiple previous posts on the same topic but could not find a solution. There are many contradiciting answers in many posts.