State the differences between sql override and lookup override?

0 Answers  

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

What is the difference between a table and the materialized view?

2 Answers  

---

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

---

Explain scd type 3 through mapping.

0 Answers  

---

How can you increase the performance in joiner transformation?

0 Answers  

---

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

---

How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

0 Answers   Amazon,

---

How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,

---

What is hash partition?

2 Answers  

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

---