tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

Six Stars

tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

Hi,

 

I'm using tpostgresSCD  and I'm using current record indicator option for SCD2.

Its working fine but, In the target I get 't'(true) or 'f'(false), the requirement needs 'Y' or 'N' for that column. Can I hard code it anywhere?

 

Regards,

Sai.


Accepted Solutions
Forteen Stars

Re: tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

The other way ,while creating a report,you can derive Y & N based on Boolean value which you loaded.
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

All Replies
Forteen Stars

Re: tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

@newbie_496, Since you cannnot hard code but as part of work arround you can do in tPostJob need to update from t to Y and f to N in tPostgresqlrow.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

@newbie_496,still do you have issue.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

yes, the output of the tpostgresqlscd active records is Boolean, now I can't pass the character values "Y" or"N"

Six Stars

Re: tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

@manodwhb yes, the output of the tpostgresqlscd active records is Boolean, now I can't pass the character values "Y" or"N"

Forteen Stars

Re: tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

@newbie_496,since you cannot pass Y and N,as part of work around you create a new column in table and mark Y or N based on the boolean coumn in tPostJob if you needed.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

@manodwhb thanks, but this not a quality design as per the table is considered.

The user may get confused.

any ways thanks for the input.

 

Forteen Stars

Re: tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

The other way ,while creating a report,you can derive Y & N based on Boolean value which you loaded.
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Six Stars

Re: tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

Sure, We are considering this option for now.

 

Thank you!

Forteen Stars

Re: tpostgresSCD or any SCD component: How to get 'Y' or 'N' instead of 't' or 'f' on Active record??

Please accept the solution,which one is help and also provide Kudos.
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download