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 a difference between complete, stop and abort?

1125

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1310

---

How to improve the performance of a session using sorter transformation?

1191

---

Can we get 1st record through Informatica(without sequence number).

1520

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4252

---

Explain the difference between a data warehouse and a data mart?

1112

---

State the limitations where we cannot use joiner in the mapping pipeline?

1106

---

How can we store previous session logs?

1140

---

How big was your fact table

1864

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1557

---

What is the way to execute pl/sql script using informatica mapping?

1681

---

lookup transformation with screenshots

4050

---

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

1170

---

Tell me about MD5 functions in informatica

983

---

What is a filter transformation and why it is an active one?

1015

---