DSXchange

Hai,

I have installed datastage 7.5 version in my pc, but transformer stage is not working.

regards,
murali

Due to installation problem, you might get this problem. So kindly reinstall it.

Hai Same partition can't be used in transformer bcos if u r using the hash/entire/any other partition before transformer or any other stage, if u want to continue the hash partition for the remaining part of u r job, then go for the same partition. for lookup better to use entire partition & for...

Hai Friends, I m having the two source file. 1st Source File Contains id_code A138 2nd Source File Contains Name,age xxxx,12 yyyyy,13 zzzzzz,14 From the two source file, i want to concatenate id_code & name together. I have used surrogate key, join & transformer for concatenation. But i was ...

Use the copy stage, it is better in case of performance & it is faster.
We can also take the copy of the target file.

What is the difference between the change capture & change Apply?

Hai,

One of u r column contains the varchar as its datatype. But you want to extract the numeric values.

There is an option in transformer stage, goto functions----->
As integer(columnname)

row generator---->modifystage----->target In my row generator, i am having two columns as name,id xxxxx,12 yyyyy,13 zzzzzz,14 for name, my datatype is varchar but in id, my datatype is varchar bcos i m unable to define the datatype as integer in row generator. so i have given as varchar for column '...

connected lookup will return more values and unconnected returns one value. conn lookup is in the same pipeline of source and it will accept dynamic caching. Unconn lookup don't have that facility but in some special cases we can use Unconnected. if o/p of one lookup is going as i/p of another looku...

Hai,

In case of join stage, meta data must be same. If we want to join two or more tables, we need a key column must be identical in all the tables. Then it works fine for you. Another use of join stage, it combines the data in sets.

Hai,

In case of join stage, meta data must be same. If we want to join two or more tables, we need a key column must be identical in all the tables. Then it works fine for you. Another use of join stage, it combines the data in sets.

Hai guys,

How to insert more than two sql query statements in the Dynamic RDBMS plugin.

Hai,

I want to know the use of exceptional Handler in job sequence.

Regards,
Murali

Hai, While executing a job, I am able to get the correct answer. But my output column occupies a large space. (i.e) single output column occupies more space. for eg. name age yyyyy 20 how to minimize the space between these two output columns.

Hi,

If you want to remove the double quotes, while u r importing the meta data
into your repository folder, a window pops up. In that specify " (double quotes) in that box.

(i.e) quote "