Interested to Buy Any Domain ? << Click Here >> for more details...
What is a code page in Informatica
- 3 Answers
- 17251 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 |
What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .
what is scd?
what are presession,postsession success and postsession failure commands ?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
Using Connected or unconnected lookup for performance wise which one is preferable?.
In a table, 4 person having same salary. How to get Third person record only?
how you will maintain version?
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
What is meant by active and passive transformation?
what is the Default Source Option For Update Strategy Transformation?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
Teradata 
