Answer Posted / murali udayagiri

Use join UNIX command in pre-session command for joining
both the files and write to a file. Use single SQ trans in
mapping to read that joined flat file data.



Thanks,
Murali Udayagiri

write a query to retrieve the latest records from the table sorted by version(scd)

1110

---

what is size of u r database?

2363

---

What are the reusable transformations?

1219

---

Explain lookup transformation is active in informatica

1147

---

Explain the difference between mapping parameter and mapping variable?

1079

---

scenario where i can use only concurrent execution of workflow.

3257

---

What is union transformation in informatica?

1192

---

Explain lookup transformation source types in informatica

1151

---

What is DR strategy for Informatica project?

1224

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2300

---

What is the session task and command task?

1113

---

How many ways are there to do 'remove duplicate records in informatica'?

1063

---

Can u generate reports in Informatica?

1143

---

what is the size of u r source(like file or table)?

2306

---

Mention few power centre client applications with their basic purpose?

999

---