DSXchange

Will you please explain the same in detailed manner,I mean the "Cycle" funda(Where actually it needs to be set)


Regards,
Balakrishna

Hi,
I'm using Column Generator stage and generating a column name DUMMY.Is there any possible way to control this column value i.e can i pass 1 as value under this column for all the incoming records,if so please explain me the procedure.



Regards,
Balakrishna

MW contains Decial values like
11.00,0.166,0.207,221.376 etc.With these values can you please let me know the outcome


Regards,
Balakrishna

The radio button checked is URL/File path.It gets automatically checked when we use External Source File stage.If we use the Sequential FIle stage then it is the XML Document checked by Default.In my case as i've used External Source File stage,URL/File path Radio button is checked Regards, Balakris...

Hi, I have a doubt in using the Compare function in Datastage. This function is used as If (Compare (Trim(EXSTCRR_TRANS.MW , '0' , 'R') ,'.' ) = 0) Then 0 Else 1 If (Compare (Trim(EXSTCRR_TRANS.MW , '0' , 'R') ,'' ) = 0) Then 0 Else 1 What's the actual output of this function in the scenario mention...

Hi Raju,
The output of External Source stage contains only one record and i'm taking Nomination Id as the key field which has unique values in the entire file.


Regards,
Balakrishna

On whole i'm narrating the procedure incorporated, Initially I imported the table definitions(Import-> Table definitions-> XML Table Definitions.I have opened the respective file and later performed Auto check(present in Edit Tab) and selected Nomination ID as the key column and saved the table defi...

Hi Ernie,
I'm following the same method that you mentioned.With that only i'm unable to fetch the records.I tried with single and multiple fileds but no change in the outcome

Regards,
Balakrishna

I have 0 warnings in my director log

Hi all, I'm facing the problem while extracting the data from XML file.I've used External Source file stage and XML input stage to extract the data.I'm able to get the datat out of External Source file stage but after the XML stage no data is being fetched.I have loaded the Meta data too.Please expl...

Hi all,
I have a problem while loading the data from the XML file.Actually the structure in XML File is in two different formats.But when i'm trying to load the data it's showing only one format.Please help me regarding this issue


Regards,
Balakrishna

Hi Everybody, I have a large sequential file which contains 15 million records.We need to insert this data into a oracle table by performing some transformations.Basically we are doing ETL transformations in our jobs to load a fact table. Our aproach is first load the sequential file data into the s...