DSXchange

Hi Guys I am extracting data from SAP BW/BI system using Hub Extraction stage. The expected number of records present in the PSA flat table is around 1000000 (1 Million). Can I extract the data from BW using the Rownum option. My idea is if at all I can specify a Rownum like in Oracle, I can possibl...

I guess I know the answer to the first one. Answer1: Enabling checkpoints in Job activity stage for each job that I use in the master sequence I still don't know the answer to the second question which is as follows: Question 2: How can you execute 10 different SQL queries using datastage in one ins...

Hi all I have two questions. Recently in an interview they had asked me this question. Can anyone suggest me an answer or where to look for the answer. I will try to look for the answer myself on the internet. Question 1: In a sequencer say there are 100 jobs and at job 50 it fails. How would you re...

Thanks Everybody.

Is it possible to remove duplicates by using the Transformer stage ? If yes then how can we accomplish that ? I was thinking to sort the data using sort stage and write a logic in the transformer stage variable and constraint to stream out the unwanted duplicate data and retain only one of the many ...

Thanks that was helpfull

Hi

Can anyone tell me what are the differences between Ascential Datastage 8.0 and 7.x and previous versions. Too mny requirements are poping up for 8.0 version these days. I tried searching on the forum but couldn't find any information. Please advice.

Thanks

I had just installed Ascential Datastage 7.5 on my machine. I built a test job (Parallel) which reads the data from a sequential file stage and write to a sequential file stage. When I try to view the data I get the following error. Error Executing view data command: <main program> APT_PMListenerPor...

Brilliant Brilliant Brilliant. Works beautifully. Thanks

The maximum possible occurance of Non-key Col2 would be 15. So I created 15 stage variables and in each stage variable I have the following logic: If keyChange = '1' Then SetNull() Else Col2 Then I map them to all 15 output columns in the transformer. After the remove duplicate logic, I get the same...

I did as you said Ray. But your process only removes the duplicates. But I still can't figure out how do I convert the vertical rows into horizontal columns.

Hi I want to achieve the following logic in my job: Input Data: Col1 Col2 A Value1 A Value2 A Value3 B Value4 B Value5 C Value6 C Value7 C Value8 C Value9 Output Data: Col1 col2 col3 col4 col5 A Value1 Value2 Value3 B Value4 Value5 C Value6 Value7 Value8 Value9 I tried to do vertical pivot using Tra...

How do I compare the data in the same table, the expected result is shown at the end: Data from Legacy: mtl bin qty sum plnt1 qty1 plnt2 qty2 1 A 4 4 2200 5 1200 8 1 B 2 6 2200 5 1200 8 split into two 1 C 2 8 2200 5 1200 8 1 D 5 13 2200 5 1200 8 I have stage variables to contain qty and qty1 sequent...

The client is loading the data using LSMW (SAP Load process) and they me to remove the unwanted tabs present at the end of each record. The records are irregular they may have 1 column, 3 columns or all columns present in various records. They occur irregularly, I was thinking to remove the end Tabs...

How can I remove the unwanted tabs from the following TAB delimited file ? Current File Structure: Column1 column2 coulmn3 A B C 1 2 3 1 2 (Blank with a Tab) A B (Blank with a Tab) A (Blank with a Tab) (Blank with a Tab) Expected file structure: Column1 column2 coulmn3 A B C 1 2 3 1 2(Since blank, N...