DSXchange

I have designed a job working fine but getting so many warnings at the funnel stage as shown below. Could you pls tell any one what is the main cause of getting the below error? fuUniqKeys: When checking operator: Operator of type "APT_FunnelOperator": will partition despite the preserve-p...

Even in one particulor document may have seveal kind of COSTCENTERS.

Sorry for got to add the above line.

Regds

Hi, In one of my job I have the following rquirement. Columns I have COMPANY COSTCENTER AMOUNT DOCUMENT I have a dataset of few records which has devided into several documents say 950 records of each document. and each document should be in the same SAPCOMAPNY and might have different costcenters. ...

mujeebur wrote:gateleys means is below:


MyString = "ABCDEF"
MySubStr = Right(MyString, 3) ;* answer is "DEF"

Mujeeb/Gateley.

Thansks lot. It's working fine.

Is these kind of built in functions where can i find in the manuals?

Regds

Hi In one of my job i has a requirement where I need to pick only last 8 digits of a particulor Column.

Can pls anybody help?

Regds

You can do one of two things. To make columns null when there is no match you need to set the column to nullable. To assign default values you need to go to the columns tab and double-click on the box with the column number to open the meta data editor. Hi When I made it is Nullable at the Joiner s...

You can do one of two things. To make columns null when there is no match you need to set the column to nullable. To assign default values you need to go to the columns tab and double-click on the box with the column number to open the meta data editor. Hi When I made it is Nullable at the Joiner s...

Hi, I am trying to Join two datasets by using Join stage and performing the Full outer Join. So I am getting the output in several fields for several unmathed rows with some defalult values . Like for date type i am getting 0001-01-01 and for Intger type I am getting Value 0 Instead of getting this ...

abhi989 wrote:In your lookup stage properties - set condition not met = Fail and Lookup Failure = Reject. Take the reject link and process that.

Hope it helps

I was done the Job which i used the logic was same as Abhi said. It's working fine.


Thanks all.

Regds

Hi, I have a requirement that needs to retrive the data from the source where the lookup is not matched. Suppose if source have the 10 records and look up has the 3 matched records remaining 7 unmatched records should be taken forward to Output link. What i am doing is i taken normal lookup and a re...

Okay, Ray points out that I didn't give an answer that doesn't require some further thought on the part of the original poster. Since the poster didn't say that there had to be an exact order to the sequencing of rows via the batch number, I stated that the data had to be processed in a sorted orde...

Hi, Is it possible to impleiment For loop by using stage variables? I has a task some thing like. I need to populate the fixed amount of records with a incrementing value as indicator based on the loading number of records. Suppose I have 200 records in my source so I need to populate each 10 record...

Did you try loading the data into Teradata table using Tpump utility. Teradata Enterprise Stage is having some restrictions for using it as Target. Please try with Tpump and let us know. Thanks Hi I am not aware of this Tpump utility. Is it available in datastage inbulit utilities? If not what is t...

Hi, Are you finding null values for all the records that are getting into the table. Did you check for warnings in the director log. Thanks, I am not getting any warnings in the log file. the status is showing finished Data Volume: ------------ Input rows: 5 Input bytes: 105 Input rows rejected: 0 ...

Hi, In one of my job there is a requierement where i has to summarize the data based on 3 different source files. So i used to combine the three files by one Merge stage and one Join stage based on Key column. My Doubt is at the merge stage if one of the Inputstream doesn't contain any data then wha...