DSXchange

could not get u

Hi All Sorry for the late response from my side.I have a little chang in my requirement.I m having a Staging table with the following columns EQUIFAX_CUST_ID CURRENT_ACCOUNT_NBR CLIENT_ID This staging table is only to load weekly data and the main table is for maintaining type 2 dimension with the f...

I would write a trigger that would fire upon every insert and it would go if pk is present, update the EFFECTIVE_END_DATE . can u please explain the concept in detail.that trigger concept.. if i add a new column to the table like update_date..wat it exactly does.will it be populated for aal the rec...

I have a table name cust_eqx_acct_dim.I am maintaining a type 2 SCD in the table.The columns in the table are : CUST_EQX_ACCT_DIM_KEY EQUIFAX_CUST_ID CURRENT_ACCOUNT_NBR EFFECTIVE_END_DATE LOAD_DATE CLIENT_ID When a new record with a new EQUIFAX_CUST_ID is inserted the EFFECTIVE_END_DATE field is se...

hi all i have some tables in the MS Sql database.i want that the data of those tables should be populated in the tables created in oracle.i have created the tales in oracle and just using a single transformer i want to populate them.but when trying to read the data in the ODBC its showing the follow...

i am very new to datastage..rather new to dataware housing.i want to know what is the basic difference between a production environment and a development environment.when we create jobs in development environment how to move them to production environment.is there any specific procedure.are these tw...

in the user defined SQL there r two spaces for writing SQL.one is source sql and other is reference sql.what should i write where.and one more thing what should be my column definations in the hash file and which one i need to specify as key in the hash file.i have never used user defined SQL in odb...

i got the solution using 2 transformer stages.in this case i have only 2 dimensions thats why its easier but if i would have 10-15 dimensions and i would approach in this way there would be a performance issue.can u plz give me details how i could use a single transformer stage to achieve this.i m u...

i could not get you.how i can use two transformer stages.can you please explain in detail

i have three source table customer,nation and region.i have created 2 hash files from customer and region.i want to populate the target table customer_d from source table.To populate nation field i am doing a look up for in nation hash file and the condition is nation.nation for customer.nationkey =...

thanks all for your help.
now i can solve the problem

ok..thanks for your reply.
if i find any extra lines how i will eliminate them.
actually i am very new to datastage.thats why i am not sure about all its features

i am still facing the problem
the error message it is showing while reading the file is
Invoice_tbl_load..Sequential_File_2.DSLink3:read_delimated()-row 6,column Acct_No,required column missing.

should i give the line termination

how can i solve that problem.can u plz explan me the funda of CR LF