DSXchange

The target is a DB2 table which will contain the structure something like this
MemberNo~Bal1~Bal2~Bal3~Bal4

The load is a daily load with updates and inserts happening regularly.

I am loading the data into the table so if the order is maintained it would be good.

Hi I am using a column import stage to convert a single column to multiple columns. I am using a schema file to create the metadata for the output. Are there any ways in which i can define the order in which the columns needs to appear in the output Eg I have a member number column and balance colum...

Actually i missed out a point in my question.
The data would look somehting like this. even if it comes likes this i need to handle it in the ETL. Will the same logic of yours work for this scenario Arnd?
Name~Balance
~~~2000
sss~9000
bbb~1000

Actually i missed out a point in my question.
The data would look somehting like this. even if it comes likes this i need to handle it in the ETL. Will the same logic of yours work for this scenario Arnd?
Name~Balance
~~~2000
sss~9000
bbb~1000

thanks !! it is not for an interview. I had a job that needs to developed so thought of posting the query. as my development data is less i could see no difference in using either method

Hi I have to do a join on two files. The join requires presorted input. hence am using Hash partition with Stable sort option on both the input links. Is this the right option to do? or should i use a same partition with sort?? Also please explain about the performance improvement that takes place i...

There are no quotes there in the file. !! It is a file from mainframe system without quotes

Hi
I have a sequential file with 2 columns and delimited by ~ .
If the data in the file is somthingike this
Name~Balance
~~~2000
Are there any ways to read the first 2 ~ into the first column and place the balance amount in the balance column?

The format is same.. but i need only limited fields.

I dint get wat you mean to say by this....
"PS : Is it your keyboard having trouble recognising character ...[/quote]"

To use field function i need to use transformer and dat wld eat up performance rt?
One point in reading specific fields is with an aim to improve performance in addition to avoid manual typin of fields..

thanx sainath.. it works

Arnd... Can u b bit more specific with ur answer. datastage sounds like greek nd latin nw.. !!

Sainath... u r tooooooooo brilliant to gve me such an answer.. Thanx

Its a comma delimiter file. and the column number is 40