What is a code page in Informatica
Answers were Sorted based on User's Feedback
Answer / shankar
The code page is used to specify the character encoding. It is selected based on the source data. We have to select appropriate code page based on the source data. You can set it in both source level as well as target FF. For source flat file, open edit table, advanced button and under that you can see code page. For example if the source contains Thai,Japanese,turky etc., we have to use corresponding code page from the list in order to make sure informatica read data properly.
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / kumar
https://etltechsolutions.wordpress.com/2014/11/06/informatica-partitioning-part-1/
| Is This Answer Correct ? | 0 Yes | 0 No |
The code page is used to specify the character encoding. It is selected based on the source data. You can set this in both source and target FF. For Flat file source you have to go to edit table-advance button- code page. Here you can see list of code pages. The purpose of each code page is specific to the type of of source data. It means you have to select corresponding code page for the source data type. Say for example if Thai, Turkey, Japanese source data you have select corresponding code page in order to make sure Informatica understands the data set correctly.
| Is This Answer Correct ? | 1 Yes | 2 No |
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
how to load rows into fact table in data warehouse
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
if we have a delimiters at unwanted places in a flat file how can we over come those.
in which situations do u go for starflake schema ?
Can we update the data in flat file using update strategy?
Limitation of REPLACESTR. Is there any character limitation to it.
What is difference between Mapplet and reusable transformation?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
How many mapplets u have created? and what is the logic used
how can we perform incremental aggregation?explain with example?
How i can upload the MainFrame source For Informatica ?