DSXchange

Thanks, Does it mean the values below coming from source (SQL server) as Float cannot be stored in the Datasets. 0.00083110025 0.001119538 3.707377834375 18585.5794375 40.3399 130.0625470625 655.9845365 I did not get "The IEEE published standards that are used widely and which offer the best co...

Thanks, Cannot keep Float as datatype in OC connector, its getting failed. Simple design. 1. OC connector -> Transformer -> Peak Stage Result - >Getting failed, source datatype is Float 2. OC connector -> Transformer -> Peak Stage Result - >Getting Success. source datatype is Double I did conversati...

Thanks for the reply.

I have tried to keep column SQL type as double in all 3 stages, but the column ouput is getting data loss as show below.

I/P -> O/P
0.00083110025 -> 0.0008311
0.001119538 -> 0.00111954
18585.5794375 -> 18585.6

Thanks,

Hi, Please need your help to the data issue. One of the column from the source (SQL server) is [varbinary](max) NULL. Its having the value as below 0xD0CF11E0A1B11AE1000000000000000000000000000000003E000300FEFF Few values exceed the lenght upto 355902. Job design ODBC Connector -> Copy -> DataSet. W...

Thanks for the reply. Source is SQL server. You mean define the column as double in OC connector and do the conversation i.,e double to float in transformer. Any idea how to convert. There's a option Schema reconciliation -> Fail on size mismatch -> NO. It worked, but there's a data loss. Thanks,

Hi, Please need your help to resolve fatal error issue. The job design is ODBC Connector -> Copy -> DataSet When I run the job, Iam getting the fatal error as below OC_Connector: Schema reconciliation detected a size mismatch for column ConversionFactor. When reading database column DFLOAT into colu...

Thank you for the reply.
The issue was resolved with the cast function as below, seems to be data issue.

select ID, Date, status, CAST(Description as varchar(250) ) as Description, Created from Headcount

Thanks,

Hi Guys, Please need your help to resolve this issue. Job design ODBC Connector -> Copy -> DataSet. When I give the below SQL query in ODBC Connector, Iam able to view data. select ID, Date, status, Description from Headcount But when I give below SQL query, its having issue. select ID, Date, status...

A "cross join" is an inner join where the condition is always met. I know its old post, but the information is wrong, just want to highlight CROSS JOIN returns the Cartesian product of rows from tables in the join. In other words, it will produce rows which combine each row from the first...

Thank you.

Hi,

Got a question from DS exam.

You have a job that reads in sequential file followed by transformer stage. When you run this job, which partitioning method will be used by default?

The answer is Round Robin.

Any idea why.

Thanks,

1) Is key based partition needed in parallel jobs ? Keyed partitioning is used when business rules (for example, Remove Duplicates) or stage requirements (for example, Join) require processing on groups of related records 2) Is Join stage running on single node ? If the configuration file is having ...

Using function as StringToDecimal(lkGeidAdded.OVERRIDE_BALANCE_UNITS,6)

Input values 20.5 , 5.5.....but output coming as 00000000000000.000000

Source file has varchar2(20) but target table has Decimal(20,6).How to convert varchar2 to decimal.i tried using StringToDecimal() function.But output coming as all ZERO's.Target values as 00000000000000.000000

Please suggest your thoughts on this ....

do initial verification how many no.of columns in the source file and how many no.of columns specified in the job. It's looks columns mismatch.... Hi, I have converted a fixed width file to a csv file using a server job. Then in the paralle job when I try to open the csv file I get the following err...