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

What are active and passive transformations?

1023

---

how tokens will generate?

2156

---

What is a router transformation?

1050

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2210

---

Design a mapping to load a target table with the following values from the above source?

1289

---

What is expression transformation?

1037

---

What is an active transformation?

1038

---

What do you understand by SOA of Informatica?

927

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1197

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1028

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2122

---

design of staging area?

1966

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1272

---

How will the document be delivered to me?

1020

---

What is the format of informatica objects in a repository?

976

---