What is a code page in Informatica

Answers were Sorted based on User's Feedback



What is a code page in Informatica..

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

What is a code page in Informatica..

Answer / kumar

https://etltechsolutions.wordpress.com/2014/11/06/informatica-partitioning-part-1/

Is This Answer Correct ?    0 Yes 0 No

What is a code page in Informatica..

Answer / 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

More Informatica Interview Questions

in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,


I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,


server hot-ws270 is connect to Repository B. What does it mean?

0 Answers   Cognizant,


Explain joiner transformation in informatica

0 Answers   Informatica,


can session assigned multiple mappings or not?

2 Answers   Zensar,






What is a connected transformation?

0 Answers   Informatica,


Implementation methodology

0 Answers  


What is sq transformation?

0 Answers  


what is surrogate id ?

3 Answers   IBM,


following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,


Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,


Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,


Categories