What is a code page in Informatica
Answer Posted / shankar_dwh
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 |
Post New Answer View All Answers
Explain the different kinds of facts.
What are mapplets? How is it different from a Reusable Transformation?
Explain what are the different types of transformation available in informatica.
What is the difference between Active and Passive transformation?
What is the surrogate key?
What does refresh system mean, and what are its distinctive choice?
Can we override a native sql query within informatica?
Explain in detail scd type 2 through mapping.
EXL informatica Questions
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
How to delete duplicate row using informatica?
How many transformations can be used in mapplets.
What are the main issues while working with flat files as source and as targets ?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?