Answer Posted / jvdwhinfo

Hi guys,

Here all the above answers are absolutely correct.
i.e we can use both concatenate operators as well as pipe
operators.We gonna get the desired output.
But only difference is the performance.We'll get better
performance by using pipe (||) operator rather than
concatenate.

Please let me know if you want to give further suggestions.
Thanks.
James

What are the limitations of joiner transformation?

1114

---

Differentiate between a database and data warehouse?

1148

---

What are the guidelines to be followed while using union transformation?

1146

---

What do you mean by channel change?

1052

---

What is a dimensional model?

988

---

Design a mapping to load a target table with the following values from the above source?

1352

---

what is the size of u r source(like file or table)?

2275

---

How many ways a relational source definition can be updated and what are they?

1019

---

What are some examples of informatica etl programs?

947

---

In informatics server which files are created during the session rums?

1121

---

What is xml source qualifier transformation in informatica?

1226

---

What is the maplet?

1131

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1909

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1958

---

design of staging area?

2031

---