This tutorial is very useful for us. Thanks for making the video, but I have a query... Suppose that we want to compare some specific data values in two different files at two different places. How will we do that ❓❓❓
Hi Azam, Dynamic Schema with database is not working when JDBC DBoutput component is used instead of the specific DBOutput component Can you pls guide how to do in such scenarios.
So if we can't parse the data in the first place itself then we need to do it in 2 steps as per your last scenario and there is no other way for the same. Please correct me. Can you explain us how can I merge all the fields in one file?
Hi, helpful video! I tried the tDbOutputBulkExec component. It is taking a lot of time to extract around 100000 records into the file, but is inserting them quickly into the DB. So for 1million, it is taking around 2hours. I used the same settings as you. How can i improve the performance to be able to have the job done in a min ? In your video, you mentioned that it can take 20 sec to copy 1 million records. Thank you in advance for your hints.
I am not good in programming also not good in sql and I am working as technical business analyst where I have to check tables in dev, prepod and prod environment can you suggest me on which topic need to study exactly Also I need to prepare technical documents such as fact, tmrt, bmt, and s2t I want to become expert in that so what will you suggest
Nice tips. I came along your video searching on How To Rename Same Names, and I watched the whole video learning new tricks but I didn't find this specific solution on your tips, and started searching the rest of the option myself. The story behind that is that I have been scraping some data from a web site getting the same name (EXAMPLE: Private) with contains unique info on each line without revealing a name. So far so good, but at the end I had thousand of same extract Names (Private) which I wanted to make them unique (by name). What I found is this: MENU --> EDIT --> COLUMN EDITOR... and then I put into the text the name I want to make unique (PRIVATE) and then NUMBER TO INSERT and choose to start from 1 (you can choose to start from whatever number you want...) and increase by 1 at a time. I clicked the position on the sheet where I want the new number to show (before the text PRIVATE or after the last letter and a space between) and clicked OK. What I got is PRIVATE 1, PRIVATE 2, etc, so now I can use the deleting double entries format without loosing any valuable data! I hope this can help
hi is there a way to sort this onee example i just want to get the "branch code #" and "total #" BRANCH 01: { 5 DATA HERE NAME AND AGE ETC FOR EXAMPLE { TOTAL 31 AND I JUST TO DELETE THE { INSIDE } AND SHOW SOMETHING LIKE THIS =============== BRANCH 01 TOTAL 31 is there a way for this ?
Excellent tutorial! Thank you for getting me started with NOTEPAD++. I can see that there are many more functions/utilities available. The Plugins have me very impressed and I need to get my head down and learn more. Thank you once more!
Is there a way to find and list all variables that contains a PPU. For example, I want to search and list all variables( ie. Xxx_yyy_ppu) in the code that contains ppu. So, after searching the code...it lists all variables that contains ppu?
I have two tabs open, new 1 and new 2. I wish to save new 2 which is active. I open the save dialogue box, name the file and save. I open the saved file and it has saved the contents of tab new 1. What am I doing wrong. This has caused me a lot of grief more than once.
Hello I am trying to update context variable value from tjava using context.var=new_value And printing this var in another tjava component using context.var But value is coming blank.??
Hi, I have a case where I need to give text file, userid , password as input to batch file using tsystem component. I tried like below "cmd /c D:/Noor.bat "+context.folder+"file.txt userid password" Getting Error : " The filename, directory name, or volume label syntax is incorrect". Could you please tell me why where I'm mistaken
with commit every statement, all commands are auto committed which means you cannot roll back... with the tOracleCommit option, you can decide when you want to make a commit... it gives you more flexibility.. you can also learn more details from my udemy course: www.udemy.com/course/talend-data-integration-using-talend-open-studio/?referralCode=00F56563FA9680DE364D
Questions Can we use Global variable in all job inside project How can we assign global variable from parent job child job and different job What is use of tJoin when we already have tMap What is real time scenario where you used Routine