Answer Posted / shalu

giving one example, lets say my table temp is having
following -

col1 col2
1 2
1 2
1 2
3 4
3 4
5 6

In the SQL Qualifier, override the query as
select col1,col2,count(1) total from temp group by col1,col2

which shows the output as
col1 col2 total
1 2 3
3 4 2
5 6 1

Now, use one router transformation where one condition is
where total >=1
and second condition where total>1

So first condition will return you all the unique records
1 2
3 4
5 6


and second condition will return you duplicate records
1 2
3 4

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6147

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1244

---

How to create the source and target database connections in server manager?

1071

---

What are the different types of olap? Give an example?

1033

---

What is the cumulative sum and moving sum?

1168

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1109

---

Reusable transformation and shortcut differences

1822

---

What are Dimensional table?

1046

---

what are the deliverables?in your project?

2130

---

How we can create indexes after completing the load process?

1145

---

Where is metadata stored?

1096

---

How to delete duplicate row using informatica?

1019

---

What are the informatica performance improvement tips

1068

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7183

---

How can we create index after completion of load process?

1109

---