Answer / akhil4

infromatica product known as informatica power center.it consist of 3components
1.informatica power center client tools
in this we have
a.designer
b.repository manager
c.work flow manager
d.work flow monitor
2.informatica power center repository
3.informatica power center server

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

Explain scd type 3 through mapping.

0 Answers  

---

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,

---

What is the difference between unicode & ascii mode data movement in informatica?

1 Answers   TCS,

---

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

---

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

What is event and what are the tasks related to it?

0 Answers  

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

What is joiner change?

0 Answers  

---