Search code examples
talend

Talend data Integration : How to maintain input columns in all the components?

My Input sheet has 3 fields I1,I2 and I3

I have to insert these fields in two tables.

Table1 should have I1 and I2 from input field and It has ID as PK column. Table2 should have I3. Foreign key relation Table1 ID.

Using talend, I have inserted first two columns data in table1 (I3 is omitted in this table output component) and I have auto incremented ID. Now I want to insert ID and I3 into Table out.

But In the second table output I could not see I3 column in stream since we have omitted I3 in the first step.

Can you anyone help how to get I3 column for second table output component?

Thanks

Solution

  • I did this in following way...

    Over all job view: Over all job view

    tMap Settings: tMap Settings