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 sql override?what is the use of it?
What is the command used to run a batch?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
Can we call a stored procedure from a unix script which is run using command task
How can i send first half of the records to one target and Remaining to other target?
what is the difference between repository & Intergration service
What is the different lookup cache(s)?
How do you update the records with or without using update strategy?
why we use materialized view over view?
Why we need XMLs?