CODEWITHSUNDEEP
informaticaiics
Brenton Pyles
Brenton Pyles

Reputation: 1

Informatica Cloud (IICS): Can Target transformation pre and post sql include incoming data?

I have a Target insert transformation that I'd like to do a delete on the row before insertion (weird niche case that may pop up).

I know the update override allows for :TU.xyz to point at incoming data, but Pre/Post SQL doesn't have the same configure menu.

How would I accomplish this correctly?

Upvotes: 0

Views: 666

Answers (2)

summer fondness
summer fondness

Reputation: 101

Maciejg is correct, there is no dynamic use of Pre and Post SQL.

I would normally recommend an Upsert approach.

But, I found using a MS SQL target, IICS has a bug with doing Insert and Update off a Router. The workaround of using a data driven operation removes batch loading on your insert, so... I now recommend a full data load approach.

From a target with the operation set to Insert, I do batch deletes with Pre SQL. I found this faster and more cost affective than doing delete/insert/update operations individually.

Upvotes: 0

Maciejg
Maciejg

Reputation: 3378

From what I recall, Pre- and Post- SQL uses a separate connection so there is no way of referring incoming data.

One thing you could do is flagging/storing the key somewhere and using the flag/instance in the PostSQL query, for example.

Upvotes: 0

Related Questions