I am facing an issue with Informatica Cloud. I am very new to the system. I need to parse a XML which has various nodes in it. For this I have used a Hierarchy Parser and from that to a Sorted output and used Joiner to join different nodes in the XML. Since there were different Joiners, I have clubbed them into a singe Joiner and send the output to the Target. But I am getting an error Two active transformations cannot flow into a passive transformation.. Informatica cloud help provided me the below link [ERROR: "Two Active transformations cannot flow into a passive transformation" while validating a mapping in IICS][1]
[1]: https://kb.informatica.com/solution/23/pages/59/501727.aspx, but I am not sure which is the Passive Transformation here. I am using only Source, Hierarchy Parser, Sorted Output, Joiners and Target. I am in a critical situation. So any help will be much appreciated.
Pls follow some basics while working with joiner/multiple sources -
i. use n-1 joiners for n sources/pipelines. So, if you want to join 2 source, you need 1 joiner, if you want to join 3 sources, you need to use 2 joiners and so on.
ii. sometime you need to do self join, you need to sort the data before joining.
iii. you can join or union two active transformations
iv. active transformation is something that can change number of rows