Importing boolean from Informatica for List subset

I am trying to populate a subset using an import triggered through Informatica.

Here is how the import is set up in Anaplan ("SS PortCo in Hierarchy" is the list subset):

Now from Informatica standpoint, every record captured by the query needs to be added to the subset so I am using a hard coded expression instead of mapping a field from the source:

Screenshot 2

This unfortunately does not result in any item being added to the subset despite "65 rows processed" in Informatica. I have also tried to use 1 instead of TRUE.

Has anyone attempted something similar?

Regards,

Guillaume

Screenshot_1_50650.png

Screenshot_2_50650.png

Accepted answers

All comments

kavinkumar

HI @Guillaume_D,

Note: Put the import action in a process and then use it in Informatica. Still facing the issue? try the below one.

I hope you are using Synchronization task to run an import action. If I understood correctly, your import action is within a model or Model to model import and doesn't involve any file upload. If that is the case, in Informatica you have to create a 'Dummy connection' as Source and Your model as 'Target'. To elaborate, to trigger any action in a model keep that model as Target connection and Source as 'Dummy connection'. So this Dummy connection could be anything, a flat file (Stored in the server) or Your external 3rd party system (Oracle,SAP,etc..) all you need is a Table with hearer. So once you set the connections, in field mapping map any header from source to the Target (which is your action). It should work. Please try and let me know in case of any concerns.

Regards,

Kavin.

Guillaume_D

Thank you @kavinkumar for your help with this matter. I was able to go around the problem by creating a model-to-model import and wrapping it in a Process action that I call from Informatica like you suggested.

This works well for what I am trying to do but it is slightly different from what I was inquiring about (I should have explained better). The import I created initially and documented in screenshot 1 is a file Import in Anaplan that I was trying to map in an Informatica Synchronization task. The idea with this task was to match multiple list items in Anaplan with Salesforce records (the source in the sync. task) and systematically make these part of a subset. In order to do that I have mapped the list items with the ids I have selected from SalesForce and wanted to create an expression in Informatica to include these items in the "Add_to_Hierarchy_" subset (cf. Screenshot 2). Because subsets are treated as booleans in Anaplan I figured I needed to create a "TRUE" expression but that did not work. There is an "Edit Types" button in the mapping screen in Informatica but it is not possible to select anything else other than string so I wonder whether it is even possible to import data in Anaplan directly as boolean (wchich would be necessary to update list subsets).

rob_marshall

@Guillaume_D ,

I haven't played with Informatica in a long time, but you should be able to import a string with the value of "TRUE" into the boolean for the subset. Again, this should work.

Rob

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…