DSXchange

Its possible.. First use a filter stage using two where class namely year=1981 and year =1980. In the filter output1 change year as year1 and in filter output2 change year as year2, same for sal also change as sal1 & sal2. Now merge the two filtered output using a merge stage with empid as key. ...

Its possible.. First use a filter stage using two where class namely year=1981 and year =1980. In the filter output1 change year as year1 and in filter output2 change year as year2, same for sal also change as sal1 & sal2. Now merge the two filtered output using a merge stage with empid as key. ...

What is the use of process control table in job sequence??

Use Two SUrrogate key generator one after each sequential file stage, then use a merge stage and in the merge stage output mapping remove the key that is generated using surrogate key generator. note tat while using surrogate key generator use same name as key for both surrogate key generators.

hi ray can u tel me wat does a reporting tool does actually, and wat the datastage should do, as u said i'm using a wrong tool... I'm having a query to find the maximum profitable branch out of five branches, if its possible to execute this query in sql why not in datastage..

Hi friends, i cant use aggregator stage as i'm having five different branches so it'l give five branch details as i'm gouping by branch id. but i need only the branch with which is most profitable alone. And also i cant use sorting and get the first data alone as there wil be a problem if two branch...

No,i need in datastage

I am having five branches and my query is to caluclate the maximum profitable branch.By using aggregator,br_id as group key i am getting 5 rows with maximum profit of each branch,but i need only one row containing the most profitable branch among all the branches to be displayed.. Can anyone solve m...

There may be data type mismatch,so try it up with some other datatype. Varchar is more preferred if the field contains special characters,characters and numbers

For the column that's showing warning,set the nullable property in the column tab of the aggregator stage as 'yes' then go to target stage and click the particular column so that the extended properties window will appear and in that set the null field value as ''''. Sure u wont get any such warning...

Hi.. can anyone tel me how does hash partitioning works?

yeah,it's possible to use brackets in the filter stage, i tried it's working.