DSXchange

chulett wrote:It simply means that there is no column named "enddate" in your table.

I see enddate in my table which is a reference table but i dont see enddate in my source table.so please can you tell me do i need to have enddate in my source table too.

thanks in advance

Hi everyone, I am trying to implement scd2 with the surrogatekey .i am getting an error while executing CopyOfjs_scd1_SK..xfm1: |CopyOfjs_scd1_SK..ODBC_47.update: DSD.BCIOpenW call to SQLPrepare failed. SELECT "sid","storeid","name","city","state",&q...

if i know the answer why would i post it. It's a standard practice and just common courtesy to post answers, regardless of where they come from, even if you end up having to supply them yourself. This helps future searchers who come here looking for the same answer. I didnt mean in a negative way a...

I see the 'Cmplete Set' in Merge.i will try it and find out if i can work it out or not.But i searched in google and read in some document that merge can work for full outer join.So i will try with 'complete set' and see if it works ornot.

No , I havent tried "Complete Set".Please can u tell me what is this.Is this a stage.I dont have any knowledge regarding this.

hi everyone ,

Can anyone tell me the process of getting a full outer join, as in serer we cant get the full outer join through merge stage, i was wondering if there is any other process to find the full outer join .If so , can anybody tell me the process.


Thanks in advance

Neither one "drops" the table. And you have the documentation, I don't, so why not simply look it up and tell us? I dont have any documentation, as anbu said the functionality based on the documentation, if i know the answer why would i post it.i searched in the google but i didnt find th...

As per the Documentation , it has the same functionality for DB2, Informix but Oracle has different functionality.So i want to know how does it differ for SQL Server .Does it provides the same functionality for the SQL Server too or provides different functionality as my target database is SQLServer...

Read what was posted a little more carefully. ... I do understood what anbu has said previously.but i am not asking about the one which he has posted.As he said,"Clear table then insert rows" and "Truncate table then insert rows" are same in DB2,Informix. And there is only optio...

So, finally you mean "Clear table then insert rows" is same as "Truncate table then insert rows ". But i see both the options in Oracle stage and i see only one of the option "Clear table then insert rows" in remaining stages like Informix,DB@,ODBC etc.If both are the s...

Clear table then insert rows - Delete the rows from the table Truncate table then insert rows - Drop the table. Hi anbu, I am confused, do u mean that "Truncate table then insert rows" means there wont be any table as you said which is Drop the table i.e. table is going to be deleted. Fro...

What stage are you using? Most would have an update action similiar to "Clear table then insert rows" which would do the truncate for you. ... I am using ODBC stage , so you mean the update action "Clear table then insert rows" is to do the truncate and insert the rows.Because i...

Delete the table in Before Sql and then do the insert My job is to load all the data from the source but have to load the data after i truncate the target only if there is any data in the target table if not just load.So i dont want to delete the table instead just need to truncate the table. Thank...

Hi everyone , My job is to truncate the target table and then has to insert the rows.My target here is Sql Server. is there any solution?I think we can call the stored procedure to do the truncate option but i want to know is there any other way to truncate the table first and insert rows. thanks in...

Oh , that might be the problem. Thanks a lot.
And i need to compare source and reference without look up. is there anyway that we can do. i am using both as the flat files not the databases.