DSXchange

I have records coming in as duplicated and have same dates and different times. I also have a uniquekey personnumber which is unique for each person. Can anyone suggest me a stage where I can get the max time for that particular day and pick that single record and eliminate the records of other timi...

Ok. I will try to check for each pass by comparing as the records are sorted. In the path field below Is there a function to find the node next to the node which is found. I mean lets say If the input record coming to the tramsformer Is X It needs to check the path records and find it and then next ...

Actually if a node is expired its below level nodes are to be expired and then its below levels nodes till the end of the tree are expired. they are related with node , next_level(toplevel above the node) and path also which shoes the path(ex last path X/A/B If a expires then B and then nodes for wh...

I have three fields node,node_level,path which has values like below node :A|G|J|H|B|I|C|E| next_level:X|X|G|G|A|G|A|B| Path:/X|/X|/X/G|/X/G|/X/A|/X/G|/X/A|/X/A/B| ignore the pipe(|) in between the records for the three fields and the rest are the records in the table. If lets say the next_level exp...

This is a typical typeII job where we capture changes and update the records. But before CDC we need to send the records with the parent key which we get after doing lookup with the target. If an other job is developed in the above kind of scenario we cannot compare the keys and also it may not pick...

This field cannot be populated into the target before loading the parent record. In this scenario the records from the source enter as each group which form unique with hiername and effdate. Like first 5 records belong to one group and next 4 records next group and 6 records third group and so on......

I tried to do sparse lookup with the target to get the primary key value which is to be loaded but that did not help? I need to load a record and do lookup with the record and load second record and then lookup second record........ Also committed after 1 row in the target but still the field is not...

In my requirement a table is loaded with a primary key and in the middle of the job this primary key is taken as another field to get loaded. I need to do lookup with the target to get this primary key and use this to load another field. Please suggest how can I do this with commit each row after lo...

Thanks

Used unicode for all char and varchar fields also checked the NLS settings at project level which says loaded for all maps.



Please suggest what is supported mappings? do you mean the mappings before the sequential file.

Actually all the lookups have continue and I am capturing the rejects at the end of the job by filtering the '0' values.

The only thing is usually if a lookup failure occurs the value '0' is given when continue is used, but in this situation the records are dropping.

Actually all the lookups have continue and I am capturing the rejects at the end of the job by filtering the '0' values.

The only thing is usually if a lookup failure occurs the value '0' is given when continue is used, but in this situation the records are dropping.

There were around 5 jobs which has no dropped records and all the fileds have been given NVL in the source query. All the jobs were running fine. All of a sudden the records are getting dropped in the transformer stage which is between two lookups for all the 5 jobs. please suggest me if I need to c...

Do you mean the metadata coming in?

There are other jobs which are of same kind but they do not show this warning.


Do I need to check the fields and data in it?

I have a warning from sequential stage which is capturing rejects from table.


Invalid character conversion found converting to ISO_8859-1:1987, substituting.


please suggest if any changes are required?



Thanks

Actually this is a file used for capturing rejects from a table.

Is there any way to remove the fixed length in that sequential file?