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.

Answer / kumar

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

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.

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.

1 Answers   Amdocs,

---

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,

---

Briefly explain the aggregator transformation?

0 Answers  

---

how to connect two or more table with single source qualifier?

4 Answers   IBM,

---

What is the status code in stored procedure transformation?

0 Answers   Informatica,

---

---

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

---

what is lookup ?

7 Answers  

---

How to do unit testing in informatica?

0 Answers  

---

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

---

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,

---

explain abt joiner t/r?

1 Answers   IBM,

---

What is data merging,data cleansing,sampling?

4 Answers  

---