Interested to Buy Any Domain ? << Click Here >> for more details...
What is a code page in Informatica
- 3 Answers
- 17037 Views
- American Express, Cognizant, Deloitte, I also Faced
- E-Mail Answers
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 |
Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?
What is the difference Between Mapping parameter and variable
how remove 1st 3 records & last 3 records in informatics
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is informatica etl tool?
how to get flatfile containg 10 records half records one target another half another target
What are the rank caches?
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
can v update d records in target using update stargey without generationg primary key ? explain
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
Teradata 
