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

What is mapplet in informatica?

588

---

what is the hint? how to use it to reduce the query processing in program?

6271

---

How do you load only null records into target? Explain through mapping flow.

1489

---

What are the differences between a connected lookup and unconnected lookup?

638

---

How to join three sources using joiner?

561

---

---

Why union transformation is an active transformation?

649

---

Explain scd type 3 through mapping.

576

---

What is an expression transformation in informatica?

512

---

What does reusable transformation mean?

663

---

Define the various join types of joiner transformation?

556

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5557

---

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2418

---

How to create a non-reusable instance of reusable transformations?

670

---

What is meant by query override?

630

---

What is transformation?

651

---