DSXchange

When i try to load the data only NULL's are getting loaded.

I have used userdefined SQL ,as i had to convert date fields to to_char in order to conform with date format in the target.

HI Iam reading the data from Oracle connector stage and loading in to Sql server using ODBC stage.I have made Enable Partitioned reads to Yes in oracle connector stage.This is my query by default it takes rowid partition SELECT ROW_ID, TO_CHAR(CREATED,'YYYY-MM-DD HH24:MI:SS'), CREATED_BY, TO_CHAR(LA...

HI All We are in process of migrating data from Oracle to 9i to MS Sql 2005. There are some oracle tables containing long datatype ,when iam trying to select the table containing long column data is not displayed.I would like to know if there is any option which i need to select in oracle connector ...

If it is verticle pivot for rows in to column we can acheive it in transformer,but here the rows should be concatenated in to single column.

HI
I have Requirement like this

Input
PID JOBNAME
1 A
1 B
1 C
.
.
. X


My output should be

PID JOBNAME
1 A,B,C.,.,.X

Could you please help me in acheiving in datastage

Thanks in Advance
Mohammed Tausif

HI All I have a job which is extracting the data by grouping on some feilds using DRS stage Query SELECT A,B,C,D,E,F,G,SUM(H) FROM TAB GROUP BY A,B,C,D,E,F,G The it is doing direct lookup with ODBC stage ,reason iam using ODBC stage here is to check the option in Transfromer stage" Refrence lin...

The metadata and amount of records in both the HASHFILE's are same,
the file names and data are different though.I think this will not be a problem becuase the data gets loaded in HASHFILE1 ,while the job hangs while loading in to HASHFILE2

If I remove the HASHFILE 1 ,Iam facing the same issue.

"preload file to memory " ? where do i need to set that,the size of refrence file is not that big.

HI All I have a job which hangs when using Hash file as a lookup. My job design is like this !-------------HASHFILE1 ! ! ! ! ! ! ! ! ! ! DRS-----------TRANS1------------TRNAS2-----------SEQFILE ! ! ! ! ! ! ! ! AGG------------HASHFILE2 The First HASHFILE1 is looked up with TRANS! and Second HASHFILE2...

can you suggest some fonctions or routiens to direct the values from the source to the respective columns in the target based on the conditions.Because right now the main problem is that we can satisfy the conditions creating a file having all the possible combinations.But in the transformer how can...

I have 11 source and out of these you have 8 colums from each source coming out to the target based on the condition.So i can take all the possible colums from the source .filter that columns based on the conditions in the flat file.Now the problem is that for one condition there are different combi...

But my client wants me to use Single source table .And he wants me to check the data coming from the table in a file which has all the possible combinations of the conditions aas a look up.BUt the proble is that we can stisfy the conditions but we cannot direct which source value should go to which ...

Hi! I have 11 sources each source has different conditions .I have to retrive 8 fields from each of the sources an the target is flat file having 16 standard fields .I need to map these 8 values coming from sourec to the respective target columns.Can you ppl give an suggestion to arrive to an simple...