Hello

1-) Check Whether the value null

Yes, you can check the value if it is null and handle the null value on tMap, for example:
tFileInputXML--row1-->tMap--tMysqlOutput
row1.columnName==null?value1:value2
There are many such case on forum, pleasr search and learn it.

2-) Check  the existence of values in the dimension tables (For instance; my output table is "orders" and I will check the the existence of the "customer_id" column from "customer" table)

Select the 'insert or update' item on the action on data list of txxxOutput component. Maybe you need do some inner join between order table and customer table.

I will collect the all results and then send mail them to a mail address. And then die and rollback the transaction for that file(!)
If it is sensible, How can I achieve this (Maybe tLogCatcher, tAssert.....etc.) ?

Please see the user documentaion and learn the following component:
tMysqlConnection, tMysqlCommite, tDie, tSendeMail.

Best regards
Shong

Hello

What should I do about the tFileInputXML (firstly) properties?

Did you see my screenshot? I have showed how to define the schema, mapping based on your xml file.
As I said, you have to learn how to create xml metadata and how to use the metadata on tFileInputXML component, just create a simple job to learn how to extract records from a xml file and output it to console. for example:
1)Go to Repository-->Metadata and right click on File xml, select 'create file xml' to create a xml metadata follows the wizards.
2)Create a simple job,
tFileInputXML--main--tLogRow

on tFileInputXML, choose 'repository' on property type list and choose the xml metadata just created by you.

Best regards
Shong

I am sorry for persistant demand Because of being placed in difficult circumstances! But I persuaded my manager to use TOS after a long and hard demo. But I achieved that we took a full liecence to use TOS    :-)
My Main Goal is to take data from our customers via XML. The put put their XML files,whose basenames are formatted (XXX-Cust_ID-YEAR-TERM-SYSDATE.xml) special to them , in a common FTP folder.
I will take these files from FTP and copy to my locale and then insert (second phase has also UPDATE but not now) datas into Oracle with both splitting basename and xml nodes together.
Now I follow the order you suggested to me :  [ tFTPGet -->(iterate)--> tFileList -->(iterate)--> tFileProperties -->(main)--> tJavaRow ] -->(OnComponentOk)--> [ tFileInputXML -->(Main)--> tMap -->(Main)--> tOracleOuptput ]
I got the files to my locale folder. Get the property of each file and parse the info by splitting basename into Context variables in tJavaRow. But at this point ı stopped. My files not predefined, they will be live at run-time. So I have to set properties of tFileInputXML &  tMap manually.

For tFileInputXML;,
--------------------------
filename => "((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))"
LoopXPathQuery => "/stats/stat"
Schema => ???
Mapping => ???
--------------------------

And My Xml structure:
--------------------------
<?xml version="1.0" encoding="UTF-8"?>
<stats>
    <stat>
        <key>002</key>
        <value>12032019</value>
    </stat>
    <stat>
        <key>003</key>
        <value>12032010</value>
    </stat>
</stats>
--------------------------
What should I do about the tFileInputXML (firstly) properties?

Thanks for responses again,
Mevlut.

NO COMMENT ???

Hi againn,

I tried what you said in order (as you suggeted) but havent succeded yet :-))
I have lots of xml files. I declared 4 context variables because of basename of my files have a format. I split them in cod pane of tJavaRow component and assign them to context variables.
Then I use the "((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))" expression where the file needed and it works. untill the tFileInputXML component.

My XML :

<?xml version="1.0" encoding="UTF-8"?>
<stats>
    <stat>
        <key>002</key>
        <value>12032019</value>
    </stat>
    <stat>
        <key>003</key>
        <value>12032010</value>
    </stat>
</stats>

And my output table (BKS_STAT)  has columns (ID,KEY,VALUE)

Q.1) How can I use tFileInputXML component for the xml files that have same format but that will be apparent on run-time ?
Q.2) Also use tMap usage is not clear without knowing the answer of the Q.1 !!!
Q.2) Can I use Sequence (in Oracle) for ID column ?
Q.3) is sing Context for split basename into 4 pieces (I will use them to insert BKS_STAT table with the ID, KEY, VALUE) sensible ?

Thank you very muck for your responses,
Best regards,
Mevlut.

Hello
Q.1) tFileList? tFTPFileList?
==>tFileList
Q.2) There is no "main" opiton from both tFileList & tFTPFileList. There is only iterate. So ?
==>Yes, it is not a input/output component, so thare is not a 'main' connector, please see the user documentaion and learn its usage.

Best regards
Shong

Hi shong,
I will try and back to here with my results and feedbacks...
Thank you very much...
Mevlut