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

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1092

---

What is the surrogate key?

1252

---

Explain in detail about scd type 1 through mapping.

1546

---

where to store informatica rejected data?

1093

---

How do you convert single row from source into three rows into target?

1153

---

What is depict expression change?

1111

---

How can one identify whether mapping is correct or not without connecting session?

1437

---

What is Cognos script editor?

4222

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2173

---

How to create or import flat file definition in to the warehouse designer?

1067

---

What is main use of mapplet?

1127

---

which one is better performance wise joiner or look up

1086

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1123

---

What is joiner transformation in informatica?

1043

---

How to load the data from people soft hrm to people soft erm using informatica?

1008

---