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 are the components of workflow manager?

1017

---

lookup transformation with screenshots

3938

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

988

---

What are the differences between oltp and olap?

920

---

What is the difference between a repository server and a powerhouse?

1409

---

Please let me know how to make encryption and decryption with example?

1846

---

How do you migrate data from one environment to another?

1041

---

whats the logic to load the lower level of granularity of data to fact table.

2205

---

can anyone suggest best free Talend data integration training online

1622

---

What are ETL Tools?

1039

---

Explain your project of banking domian.

1605

---

What are some examples of informatica etl programs?

884

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1804

---

What's the layout of parameter file (what does a parameter file contain?)?

2331

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1025

---