rejected rows, notifications ect.

[ProDev]

Hi,

I am new to Informatica, trying to lean by myself ...

Please clarify the followings for me.

1.) In real time Data warehosing project, how do you guys handle the rejected rows in Informatica ? I mean, what are all steps involved in dealing with such rejected rows while doing an ETL using informatica ? Please explain with example if possible.

2.) Can anyone please guide me, how to do a notification about the failure /success of a session. (if i am not wrong you guys might be calling a shell program in "Post-Session" whcih must be taking care of this. But can you pls explain how do you write such shell).

Thanks

 

[smajay]

1. You can handle rejected rows by looking at bad file which gets created if records are rejected. you can correct the records in reject file and then can load again.

2. Email notification can be send using the post session tab of the session. You need to just specify the email address and subject for success and failure of session in success and failure tab.
Along with that you can also send all the details like no. of rows loaded and no. of rows recjected using different variables.

 

[reachbgk]

1) For the rejected rows - i normally put it in a exception table with an indication of why the record was rejected. You can output the rejected rows to a file too. The advantage a table ahs is that my users query the exception table and can look at how many rows were rejected and why.

2) I use the post session tab to send an email to the support pager which rotates between a bunch of people.

 

[ProDev]

Hi Smajay,

Thanks for your response.

Well, going into a bit more on 1st question's solution, how do you prepare a source flat file (or table) from the .bad file, once you are done with the corrections. In other words, can you pls elaborate how the correction needed to be done at rejected files and then how do you get your source ready for a next load. Is it all manual, i doubt. Pls explain ...

Regards

 

[reachbgk]

My source in this case is flat files. The rejected rows go into exceptoin table. A report is sent to the users showing why the rows were rejetced. The users prepare a file with only the corrected rows (in the same file format as the original file) and send it back to us. We then reload the corrected file.

 

[ProDev]

HGi reachbgk,

What is code in Informatica do you write and where do you write to send all rejected records into ceratin relational table(instead of the default ".bad" file).


Thanx