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

How to go to the older version for a mapping?

1112

---

Is stop and abort are same in informatica?

1013

---

Why is sorter an active transformation?

1138

---

What is depict expression change?

1132

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2433

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1338

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1592

---

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

2036

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2143

---

Which are the different editions of informatica powercenter that are available?

1036

---

Differentiate between a repository server and a powerhouse?

1129

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7471

---

How would you copy the content of one repository to another repository?

1030

---

Can we create two repositories on same database instance in oracle?

1111

---

What is the use of target designer?

1064

---