DSXchange

Is there a way, we can get the count of input records written to a output column without using a aggregator stage.

Hi All, In one of my job i'm joining 2 datasets by using a join stage based on 4 keys. I'm clearing the partitioning in both the datasets while reading them & in the partitioning tab of the join stage i'm performing the Hash partioning on the join keys & enabled the perform sort (sorting the...

Is your output date or a string format? Lets start with that before we jump any forward. hi the target column for the date is in the verchar thank you Hi, Are you using this conversion as a part of your stage variables. If you are doing so, then check the order of execution of your stage variables.

I'm generating a column using column generator. Is it possible to pass a value for this column in column generator itself. I want to pass the value as 'D' for this column for all the records. Thanks in advance. A small clarification. Like if my column value is decimal,Then how could i set the defau...

Jasti wrote:Try using Algorith=Cycle,Value= D..this is working fine..

Thanks It is working fine.

As the Generator property for the field for which you want to generate the value. Right click on this field in the Columns grid, choose Edit Row from that menu, and fill in the Generator property s ... I'd set the generator property with algorithm = alphabet & the string = D But now 'D' was not...

ray.wurlod wrote:Use a Cycle with just one Value, "D". ...

where should i give this value in coulmn generator

I'm generating a column using column generator.
Is it possible to pass a value for this column in column generator itself.
I want to pass the value as 'D' for this column for all the records.

Thanks in advance.

I'm doing a CDC of a sequentila file with a dataset & capturing the records which is preset in the sequental file & not present in the dataset.
I've to delete these particular records in the sequential file,how to achieve this.

Thanks in Advance.

Hi, Please advice on following situation. I have a value coming from the source which normally should look like this '20080701' or '20071105' but sometimes they delivered this '20080000'. I want to build a check in the stage variables to exclude these incorrect values. Please advice me how to check...

Hi Satish, what kind of partitioning ur applying? Instead of aplying a explicit sort stage,why don't u try sorting in the partition. How you are telling that the second sort is gving only 2500 records,if u r seeing through the perormance statistics,then u hv to give more info of what kind of join u ...

Hi Ray, Sorry for disturbing u,,,I am not premium member could you please let me know the solution for this. My assumption is using the copy stage we can rename the Main link key column such as same as Lookup key column name. Can i go with this approach. Thanks, Senthil P Hi Senthil, The column nam...

Hi All, Im doing a Sparse lookup on a DB2 table.Its returing the lookup key values as Null eventhough the records in the reference table matches with that of Source table.But for the same Source and reference table,the lookup is working fine for SQL Server. Please help me in this regard. Thanks. If...

If you set the funnel type to "Sequence" it should give you the desired output. It copies all the records from the first input link, and then all the records from the second input link and so on.... My Datasets has the values like DS1: A1 B1 C1 D1 DS2: A2 B2 C2 D2 DS3: A3 B3 C3 D3 DS4: A4...

Hi, I've 4 inputs to a funnel stage. Each input dataset has values like DS1: DS2: DS3: DS4: A1 A2 A3 A4 B1 B2 B3 B4 C1 C2 C3 C4 D1 D2 D3 D4 I want the output in the format A1 B1 C1 D1 A2 B2 C2 D2 A3 B3 C3 D3 A4 B4 C4 D4 How to avial this functionality. Thanks