topic Re: is there any way to get the inserted count from tOracleRow component? in Talend Studio

is there any way to get the inserted count from tOracleRow component?

Anonymous — Wed, 15 May 2019 13:30:11 GMT

Hi All, is there any way to get the inserted count from tOracleRow component?

Re: is there any way to get the inserted count from tOracleRow component?

Anonymous — Wed, 15 May 2019 15:26:07 GMT

Yes, it's possible.

Here are the liste of available parameters

((Integer)globalMap.get("tDBRow_1_NB_LINE_INSERTED"))
((Integer)globalMap.get("tDBRow_1_NB_LINE_UPDATED"))
((Integer)globalMap.get("tDBRow_1_NB_LINE_DELETED"))
((String)globalMap.get("tDBRow_1_QUERY"))
((String)globalMap.get("tDBRow_1_ERROR_MESSAGE"))

Re: is there any way to get the inserted count from tOracleRow component?

Anonymous — Wed, 15 May 2019 15:49:11 GMT

Hello @Upendra_Balija

@dgm01 is right you can find the code at outline in studio

Please go through this url for further info

https://community.talend.com/t5/Design-and-Development/Input-of-data-to-snowflake-shows-a-different-number-of-rows/m-p/153385?author_id=19335&collapse_discussion=true&filter=authorId&q=count%20rows&search_type=thread