Where to see the final data which is ready to be transformed to target table when IH-ETL is used?

Suggy
Giga Sage

When RTE/ETL is used to load the data, we know that two tables are involved. data enters to stg table, then temp table where can we apply RTE operations like concatenation etc..

Here temp entities are defined where some data manipulation is done.

Now if I want to see what is the final values of temp entities, where can I see?

 

5 REPLIES 5

Suggy
Giga Sage

@Runjay Patel if you could help please 🙂

Runjay Patel
Giga Sage

Hi @Suggy ,

 

In same stage table you can see the processed data, if any error come that will also get log in to respective record.

Hi @Runjay Patel 

I have checked that. I dont see the temp entities, and its values, in the stg table. 

Hi

Are you referring to see manipulated data to see? if that so it wont store in stage table it will be calculated during transform of data.

 

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.


Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------