Answer / subbu

select * from table name where name is not null and
age is not null

Answer / karthis4u

select * from table name where name is not null OR
age is not null

What is the difference Between Mapping parameter and variable

3 Answers   Accenture,

---

What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

0 Answers  

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,

---

State the differences between sql override and lookup override?

0 Answers  

---

How do you remove duplicate records in informatica?

1 Answers  

---

what is update strategy transformation ?

7 Answers   TCS,

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

---

What is deployment group?

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,

---

What are the reusable transforamtions?

1 Answers  

---

What is hash partition?

2 Answers  

---