Control record Concept

[Former Member]

Hi,

I have the requirement like Control file which contains no of records. and Data file contains the records. Before starting the file to db transfer. I need to check the control record value and no of records in data file are same. How to achieve in XI.

Ravichandran K

Message was edited by:

Ravichandran Kanagasabai

[Former Member]

Hi,

Are these 2 separate files ? or are these 2 records in the same file ?

If those are 2 separate files, you would definitely need a BPM to achieve your scenario. Also you would obviously need some value to correlate between the 2 files also.

If these are 2 separate records of the same file, then you can have a map defined in your receiver determination to find the list of receivers, in the map you can check the header value and match it against the no. of records. If those 2 match the output will have the JDBC system as the receiver.

Thanks,

Renjith

[bhavesh_kantilal]

Write a module and check this in the module.

Set a flag in the module which can be used in the receievr determination to determine if the data is to be sent to JDBC or is to be ignored.

Regards

Bhavesh

[Former Member]

HI,

As explained above is little bit i understand, but

try it

-- create a MM with two messages source and target with one msg for data.

-- create a UDF check the first msg content and the msg input content is equal to the msg2 - remove context and the count then createif the -- root-- map the target node..

--create IM

So Use BPM

two recv steps and trnasformation step with the above IM, send step.

regards

Chilla.

[Former Member]

Hi Ravi,

for this you need BPM.........in BPM have two recieve steps: one for control file and secodn for data file.........then have a transformation step for mapping......generate a target msg interface similar to your data file structure....in msg mapping, have a UDF in which send input control file rec count node and data file node which is multiple for your multiple rec and output will be a boolean value of true or false............then use creatif to create target root node.........do a one-to-one mapping for remainig data file node from source data file to target file.......then have a send step to send the target XML msg to DB..........

Thanks,

Rajeev Gupta