DSXchange

Thanks DSGuru.

Could you please be more specific. If possible can you explain with an example

Hi All,

Can anyone tell me the difference between $ENV and $PROJDEF values specifying for the environmental variables.

Hi All,

I used the below code in the transformer. It is working fine.

If trim(nulltovalue(Out_IRI_UPC.PC_ID, ' '))='' then "N/A" else Out_IRI_UPC.PC_ID

Any helpon my issue

Any help on my issue

Hi All, I'm importing table definitions from SQL server tables .And some columns in the table are like below:: Promoted Group ID Promoted Group Name And in the transformer i mapped all the source columns to Target columns. It is not allowing me to map for the columns with space ..Like Promoted Group...

hello i am wondering if i have different input files with varying metadata and if i have to map the fields to the target is it going to work? whether DB is going to generate dynamic sql in oracle stage. my question is i have 2 files 1 with 5 columns and one with 6 columns i have created 2 schema fil...

hello chulett

i have mentioned the schemaname.tablename is the upsert statement. but still it is throwing error.

thanks

yes it was enabled through out the job. i used the file1 and corresponding schema file in the seqentual file stage. and in the transfomer on the target side i created 6 output columns which have same col names as in the schema file abd when i run the job it works fine. but when i use the same file 1...

Hi I have run into an issue in one of the job. Basically i am reading a file using sequential file stage and splitting the data into 2 streams based on some condition and doing the lookups on each stream and finally funneling all the data into single stream and then inserting into oracle db (uspert ...

hello ray thanks for the reply. but how can i make the job common. if i use file 1 and corresponding schema file then i need to map 6 fields to the target and if i use file 2 and the corresponding schema file then i need to map 9 fields. can this be achieved. i tried this option but didnt work. Thanks

hello i have one requirement where i need to read the first record from the file and count the number of delimters (;) in the row. ex: input file first record 123;456;789;234;567;456 then i need that record and count the number of delimters (;). the count should be 5. is there a way that i can achiv...

Hello I have a requirement where i need to read the first record of the input File and parse each and every field and need to map to the target.target being database.The file is semicoln demilited and and every field is enclosed in quotes. This job we are planning to make as common job so even other...

Hi,Please help me in checking the data spread across number of nodes in datastage directory.for example i have 100 records and there are 4 nodes defined in config file.i would like to verify nodes that are used in whatever process that is happended using any partion methods

Hi

i used secondssincefromtimestamp function to get the difference

thanks