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

How to update or delete the rows in a target, which do not have key fields?

1178

---

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

2280

---

What are ETL Tools?

1118

---

How to improve the performance of a session using sorter transformation?

1146

---

Can you use flat files in Mapplets.

2651

---

How to handle decimal places while importing a flatfile into informatica?

1192

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2131

---

Enterprise data warehouse your projects phase by phase explain?

1921

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2323

---

What is meant by active and passive transformation?

1125

---

Tell me about MD5 functions in informatica

929

---

What is a transaction control transformation?

1208

---

What is update strategy transform?

1102

---

Explain the different dimensions.

965

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3704

---