How to compare two data sources in transform map

[Rameswhar Nalaw]

If data coming for two different data source for same staging table how to compare the data in staging table and if data is not matching raise case.

[Ankur Bawiskar]

@Rameswhar Nalaw 

Not possible as both process will be async

2 data sources 1 staging table and 1 target table -> not an ideal situation

If you are having this then ensure transform map has correct set of fields mapped with coalesce or else there will be issue of data getting overrriden if same field is mapped in both the transform maps

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Rameswhar Nalaw 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.