DSXchange

Which is exactly what the Pivot stage does. Don't confuse "key" with "index" or "primary key" or anything of that ilk. For the Pivot stage, you mark as "Key" the base column(s) that should be included ... i am not able to use pivot to combine multiple rows in...

uegodawa wrote:You can use a Pivot to make columns into Rows, based on your requirements.
-U

my need is to make rows into column based on a key field

hello, I am working with legacy data that doesnot have key column in a table. beacuase of this, there are duplicate records of columns that should have only one record. I need to apply logic such that based on the business rule, one of this record is picked for extraction. Please let me know if we c...

Hello, I am extracting data from DB2 database using ODBC Enterprise stage. The DB2 source has given a sql block to pull the data. Please tell me if there is anyway / anystage where in i can give the DB2 connection and run this sql block. i could call it using a stored procedure stage but the source ...

have you tried using modify stage.

Hi,

I wanted to know how DataStage can be used with seibel.

Please let me know if anyone has worked with seibel.

Thanks

DS1

seems like i got what you are trying to say ..

thanks for all the help

DS1

hello jgreve - The starting month say eg - may , gets data from source table and that is adirect insert. however the other previous months use derived data from its preious month to get its data. the data will be in dataset . please tel how / what do u mean by custom query. hello DSguru2B - please t...

I am working on 7.1 and the sequencer doesnot have start-loop and end-loop ..

please advise

i donot see - startloop and end loop in 7.1 - I guess they are in 7.5?

7.1 is really basic at sequence.

so now what can be done in 7.1

Thanks

DS1

Thanks all of you for replying and helping. thebird is correct- ''The requirement here I believe is to run a job multiple times with different set of data each time - the input file for the job being created by the job itself in the previous run (except for the first run ofrcourse). '' - I will rese...

Hello everyone, I am working on PX 7.1 and need to create a loop to calculate data for one month and then using that data to calulate data for previous month and so forth , thus create a loop such that if in Dec - it should calculate data for 11 times. eg - using May data to get april data, using th...

Thanks everyone for the response. meena, the method you suggested is always there , thanks for it. however i wanted to know -- if only 'sum' is calculated in the aggregator stage, is it okay if i donot use a modify / transformer to make null to zero. in the dev I am not using any null to zero but th...

Hello,

the aggregator stage converts nulls to zero for the columns used for calculations.

is this a very reliable way / right way ????
or is it safer to use a modify stage before the aggregator stage to make the nulls in the caculation fields '0'

yes, i have given a thought to Craig's suggestions but i need some more help on it. I have asked for some help in previous message ---- ''''my column is in a dataset. does that make it easy / difficult ??? i tried using nested conditions, but am not sure of how to provide a condition and that too ba...