Hi All, I Need to implement below logic,Please help me out.I have the SOURCE and REFERENCE tables as below: SOURCE DATE Store Sku 1-Dec-10 A 1 2-Dec-10 B 1 3-Dec-10 C 1 3-Dec-10 B 2 3-Dec-10 B 1 REFERENCE DATE Store Sku Price 1-Dec-10 A 1 10 3-Dec-10 A 1 7 5-Dec-10 A 1 10 1-Dec-10 A 2 12 1-Dec-10 B ...
HI All, I need to implement below logic in datastage.Please help me out.I have my input data as: History Date Store Sku Price 1-Dec-10 A 1 10 1-Dec-10 A 2 12 1-Dec-10 B 1 5 1-Dec-10 B 2 8 1-Dec-10 C 1 15 2-Dec-10 A 1 10 2-Dec-10 A 2 12 2-Dec-10 B 1 5 2-Dec-10 B 2 8 2-Dec-10 C 1 15 3-Dec-10 A 1 7 3-D...
Stage variables or upstream Sort stage for detecting key change. Other stage variables for maintaining page number for output. Note that you cannot look ahead, only back. But you could sort your da ... Could you please explain me in detail.that will be more helpfull to me to proceed further. Thanks...
Hi All, I have input data as below: SESSION ID PAGE NUMBER PAGE_NAME 123 1 akajak 123 3 lkuibgt 123 7 opgyt 567 1 hagdljkh 890 1 haklik 890 4 kuioud 890 7 jhkljkl I need to implement "IF next record is the same Session_ID, then take Page_Number from the next record, subtract 1 from this Page_Nu...
First Thanks for your quick response... I'm not getting what u said... I need the output as 123,asdf,456,lkjh 234,lkjhg,NULL,NULL NULL,NULL,987,mnbv to one output and NULL,NULL,NULL,NULL NULL,NULL,NULL,NULL to another dataset.How can i perform this by using transformer stage? Thanks & Regards, k...
HI all, I have issue in handling NULLS..here is the problem description: I'm having input data as: SHOP_ID,SHOP_DESC,DEPT_ID,DEPT_DESC 123,asdf,456,lkjh 234,lkjhg,NULL,NULL NULL,NULL,NULL,NULL NULL,NULL,987,mnbv NULL,NULL,NULL,NULL I need to filter out all the null values records and only need to ou...
Hi all, I'm reading csv file using Sequential file stage with the following format: Final Delimiter=end Field Delimiter=comma Quote=double but in the source data i'm having "" with in the field itself where sequential file stage reading it as seperate field for example my source is like: P...
Hi all, I'm trying to do conversion from string to time.In the input i'm having HOUR_OF_DAY(varchar) nullability as null.first i need to handle null values and then want to convert. In th input i'm having values as HOUR_OF_DAY 4:00Am 8:00pm 6:00pm 9:00pm like wise i'm getting spaces in between.How c...
Hi All, I'm facing issue while doing look up of sequential file and dataset file. Actually In source I'm using Sequential file with Session_id(varchar),Page_number(varchar),Hour_of_day(varchar) columns and same columns coming from reference dataset file but unique records. I'm doing look up on SESSI...
Hi Kalpana, The data is loading properly in DataSet but not in DB2 table. It will work in Dataset when you copy the input link into dataset output link in which case both will have the same datatype as bigint. Maybe you are trying to push the BigInt datatype into Int column in DB2. Check it and let...