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 |
what is fact table?
how to connect two or more table with single source qualifier?
Is informatica power center designer has 64 bit support?
what is mean by grouping of condition column in lookup transformation?
Mapplets can you use an active transformation in a mapplet,
what are factless facts? And in which scenario will you use such kinds of fact tables.
how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Parameter and variable differences
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Can you start a batches with in a batch?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?