Seven Stars

Use case or more info on how to use generic schemas from repository

Hi Team,

 

Could anyone pls share any useful links or blogs reg the use of Generic schémas.

How is this different than the Metadata - File schéma or DB schema ?

and how do we use it in a job ?

 

Thanks

Vidya

 

1 ACCEPTED SOLUTION

Accepted Solutions
Employee

Re: Use case or more info on how to use generic schemas from repository

Hi Vidya,

 

     Generic schema is used where you do not want to limit the usage of schema tied to any specific file type or database type.

image.png

 

 

You can easily change a generic schema to target format. Another use of genric schema is to save the schema you have created by built in mode. When you save the data by pressing the floppy disk icon, it will be saved as generic schema for future use.

image.png

 

If the details given has helped to resolve your query, please mark the topic as solution provided. It will help to enrich Talend Community.

 

 

Warm Regards,

 

Nikhil Thampi

 

 

Tags (1)
3 REPLIES
Employee

Re: Use case or more info on how to use generic schemas from repository

Hi,

 

     Below link will give good information about generic schema.

 

https://help.talend.com/reader/QMTMLpSJZsUTFZjRCPBBNw/vQJ4wei8ZWPpd~QhKS6_7g

 

      As the name suggest, you can use this schema for any generic need compared to a specialized schema which are created for specific need (eg DB schema)

 

Warm Regards,

 

Nikhil Thampi

Tags (1)
Seven Stars

Re: Use case or more info on how to use generic schemas from repository

Hi Nikhil,
But even in the file metadata or db metadata, we can specify the no of columns required.
say an e.g i have a db table in oracle which has 10 columns however while defining the table schémas i can define specific number of columns (say only 5 columns)
Then how or when or in which compnent this generic schema can be used ?

If possible, can u share any  usecase or sample for the same .


Thanks
Vidya

Employee

Re: Use case or more info on how to use generic schemas from repository

Hi Vidya,

 

     Generic schema is used where you do not want to limit the usage of schema tied to any specific file type or database type.

image.png

 

 

You can easily change a generic schema to target format. Another use of genric schema is to save the schema you have created by built in mode. When you save the data by pressing the floppy disk icon, it will be saved as generic schema for future use.

image.png

 

If the details given has helped to resolve your query, please mark the topic as solution provided. It will help to enrich Talend Community.

 

 

Warm Regards,

 

Nikhil Thampi

 

 

Tags (1)