Thursday, August 27, 2015

Difference between tHash components and tBuffer components

tHashInput VS tBufferInput
tHashOutput VS tBufferOutput
You can use both the components to store the data and reuse it later.
tHash components are private to the job and so cannot be shared across the job.
To share data between jobs you can use the tBuffer components to move data back up to a parent job or of course write the data to a flat file or database.
If performance is a concern you could try using an in memory database such as HSQLDB to temporarily hold the data.

https://help.talend.com/images/54/bk-components-rg-542/Use_Case_tBufferInput1.png
Cheers! Uma

Monday, August 17, 2015

The differences between SID and Service Name in Oracle connection

When creating an Oracle connection, there are two types of connections that can be used:
  •  SID
  • SERVICE_NAME

The differences between those are:
  • SID = the unique name of your DB
  • ServiceName = the alias used when connecting

SID = unique name of the INSTANCE
For example, the oracle process running on the machine, the SID is the local name of the database on your system, and the Service Name is the name of the system to the outside world.
For example, you might have a QA database and a production database with the same SID but referenced with 2 different service names:
QA.WORLD =
 (DESCRIPTION =
   (ADDRESS =
      (PROTOCOL = TCP)
       (PORT = 1521)
     (HOST = QA.ACME.ORG)
   )
   (CONNECT_DATA = (SID = MYSID))
)

PROD.WORLD =
 (DESCRIPTION =
   (ADDRESS =
      (PROTOCOL = TCP)
      (PORT = 1521)
      (HOST = PROD.ACME.ORG)
   )
   (CONNECT_DATA = (SID = MYSID))

)

Cheers!
Uma

Thursday, August 13, 2015

How to use tFixedFlowInput in many ways in Talend

tFixedFlowInput allows you to generate fixed flow from many input ways.
From the three options, select the mode that you want to use.
  • Use Single Table : Enter the data that you want to generate in the relevant value field.
  • Use Inline Table : Add the row(s) that you want to generate.
  • Use Inline Content : Enter the data that you want to generate, separated by the separators that you have already defined in the Row and Field Separator fields.


The following examples shows that how to use tFixedFlowInput
Use Single Table - Hard code the value

Use Single Table - Getting values from Context
Use Single Table - Getting values from data flow via global variables

Use Inline Table - Used as Input


Use Inline Table - Used as Lookup table for modified values

 
Use Inline Content (delimited file)

Cheers!
Uma

Wednesday, August 12, 2015

How to update the latest changes to Job Conductor in Talend Administration Centre (TAC)

If you want to redeploy Job latest modification changes in TAC, in Job conductor you need to click on Generate and then click on Deploy. You can notice the status changes as Ready to generate, Ready to deploy and Ready to run.


Cheers! Uma

Sunday, August 2, 2015

How to log data in Talend Job using tLogCatcher

tLogCatcher helps to catch Warning and Errors and log data in a package. Having tLogCatcher is similar to running whole package under TRY..CATCH.
Both tDie and tWarn components are closely related to the tLogCatcher component. They generally make sense when used alongside a tLogCatcher in order for the log data collected to be encapsulated and passed on to the output defined.
The below images shows the how to use tDie, tWarn and tLogCatcher and the log data.
You can customized the log output using tMap.
Choose the required output column from tLogCatcher and also you can add new column such user.

Cheers! Uma