Answer Posted / nagraj

From SQ pass to Expression Transformation

- Take Variable for ID i.e.
V_ID =iif(not isnull(ID),ID ,V_ID )
- Take Variable for Name i.e.
iif( isnull(ID) ,CONCAT(CONCAT(LTRIM(RTRIM
(V_old_Name)),' ') ,Name),Name)

At this stage you will see the Data like this
ID Name
101 PANKAJ
101 PANKAL KUMAR
101 PANKAJ KUMAR MATHUR

Now pass the ID and NAME output port through an Aggregator
Transformation
-Take new variable for Name i.e.
New_Name=concat(concat(New_Name,' '),Name)
-Take new output port for Name and put expression for the
Name output port as follows
Out_Name=GREATEST(Name,New_Name)
- Check Group By on ID

Pass the ID and Name outpurt port to the Target.

option (truncate and load)



Where Group by on ID port

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1134

---

Plz can any one say me how to get the informatica certification materials and dumps

2050

---

Explain in detail about scd type 1 through mapping.

1555

---

tell me 5 session failure in real time how can you solve that in your project?

2305

---

How to generate sequence numbers using expression transformation?

1090

---

design of staging area?

2030

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1160

---

Explain how to import oracle sequence into informatica?

1014

---

Tell me about Propagate functions in informatica

922

---

What is update strategy transform?

1105

---

Explain how many types of dimensions are available in informatica?

1098

---

When do you use sql override in a lookup transformation?

1099

---

What all are steps in up gradation of Informatica server?

1046

---

Enlist few areas or real-time situations where informatica is required.

1086

---

What are the settings that you use to configure the joiner transformation?

1055

---