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 polling in informatica ?
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
How do you convert single row from source into three rows into target?
what is surrogate id ?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
What is aggregator transformation in informatica?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?
can we use mapplet as starting n ending object in mapping
Where are the source flat files kept before running the session?