Where to see the final data which is ready to be transformed to target table when IH-ETL is used?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2024 01:43 AM - edited ‎11-21-2024 11:47 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2024 01:43 AM
@Runjay Patel if you could help please 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2024 02:10 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2024 11:48 PM - edited ‎11-21-2024 11:49 PM
I have checked that. I dont see the temp entities, and its values, in the stg table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎11-21-2024 11:58 PM
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
-------------------------------------------------------------------------