Answer Posted / sbvp

by using union t/r
other wise create one dummy column in two tables
than join the two table with jioner t/r
ok

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

1951

---

What is a stored procedure transformation?

1050

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1007

---

How to do unit testing in informatica? How to load data in informatica ?

1119

---

Explain why we use partitioning the session in informatica?

1086

---

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8197

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1902

---

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?

1094

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1121

---

How to start a workflow using pmcmd command?

1245

---

What is the difference between source qualifier transformations source filter to filter transformation?

1043

---

Is it possible to use a client with different version than that of its Informatica server?

1134

---

draw informatica architecture 8.6 ?

3871

---

Define the various join types of joiner transformation?

986

---

How can we use mapping variables in informatica? Where do we use them?

1195

---