DSXchange

source: DAY_ID | WK_END_DT | ACT_ID|ACT_START_TIME| ACT_END_TIME| TGT_EMP_ID 2010-11-07| 2010-11-13| WRK | 22:00:00.0| 06:30:00.0| 11267 2010-11-07| 2010-11-13| BRK | 23:30:00.0| 23:45:00.0| 11267 2010-11-07| 2010-11-13| MEAL | 01:30:00.0| 02:00:00.0| 11267 2010-11-07| 2010-11-13| BRK | 04:30:00.0| ...

[quote="Sainath.Srinivasan"]What you need is a funnel and aggregator. ...[/quote] Sainath , You are right . I have used a transformer where I am taking Null Keys as right and Rest Left and then using a funnel and its working fine also . My problem is In the same join I have many fullouter ...

[quote="ray.wurlod"]A full outer join is not the same thing as a Cartesian product. Why not create an example with three rows on each input? Describe your expected output, and what you actually get. Then describe ...[/quote] Ray , example is as given below : Input 1 Locn WC Inontime 0069 1...

[quote="chulett"]Your expectations are faulty. That's the way an outer join works, full or otherwise. Any data from the 'missing' side - key fields and all - will be null. Take both. ...[/quote] Thanks For the quick response. As i have to use many full outer joins in the job how can i take...

Hi , I have a requirement to get all the matching and not matching data . So I have used a full outer join to achive this . For the matching the data is showing fine but for non matching the key fields on which I am joining coming as NULL and the derived value is coming fine . But my requirement is ...

Hi ,

The issue got resolved . Actually at the Data Base lavel the type is decimal(12,2) and before loading i had given decimal(10,2) so it was round offing . I gave decimal(10,2 ) everywhere and its working fine now .

Thanks everybody for your efforts .

[quote="ArndW"]If you do a "view data" on the source, are the numeric values displayed correctly there

When I view the data at the source the data is showing as 98.55 but in source its getting round off like 99.00

[quote="chulett"]So what stages are you using in your job? And this sum() you are fetching is using a 'group by' in your source sql I assume, yes? ...[/quote]


Stages used are DB2 Stage ,lookups ,Transformer and sequential Files.
YES I m using 'group by' in source sql

Hi , I am fetching a decimal field(10,2) as sum(skd_hrs) and loading into a fixed width sequential file as Decimal(10,2) . The problem is the value for example 89.55 is getting round of to 90.00 and so on .All the values are getting round off .Other then sum(column) i am not using any logic . Any he...

Hi ,

Which is the preffered or better File Format for Files . Is it Fixed Width or Delimited ..??

Use the following unix script .This script will satisfy ur requirement. Make the output of this script i.e (outputFile.txt) as input in the data stage job. Here InputFile.txt will be ID NAME 1 XX 1 YY 1 XY 2 SS 2 DD 2 PP awk -F ' *, *' ' END { while (++i <= c) print order[i], row[order[i]] } { row[$...

Hi , How can i load the source file metadata into the job. To be more precise i have a requirement where i need to extract the source sequential file metadata and load the same into the source stage. I dont want to define column definations in source stage rather then that i want to load the metadat...

Ray,

Just give me an idea how to develop the reusable job to compare two files based on key values. The fields to be compared should be generic.


Thanks

[quote="ray.wurlod"]"Supplied keys"? Supplied how (in a generic design)? ...[/quote]


I mean the comparision between two files will be based on key fields and these keyfields (fields to be compared )are to be supplied at run time.

Let me know if it is still not clear .


Thanks

Hi ,

Is it possible to develop a reusable/configurable job that can take 2 files and compare based on supplied keys. It should be generic and allow configuration supplied at run time what is source and destination and what are the fields to compare .