Answer Posted / suman chattopadhyay

Shirish,

Part 1 of your answer is not correct. If you use distinct
option in sorter you will get all the distinct values even
for the duplicate. i.e if the values are 1,1,2,3,3,4, you
will get 1,2,3,4 in target.

Part 2 of your answer will do all the trick for duplicate
and unique ones. If you use group by and count the number
of occurences you will get 1 as the count for unique values
and more than one as count for duplicate values. Pass those
records with count 1 to 1 target and the other to the 2nd
target.

Hope this helps.

Suman

Define mapping and session?

968

---

Explain the types of transformations?

1005

---

Under which circumstances, informatica server creates reject files?

1026

---

What is decode in static cache?

1078

---

What are roles and groups and benefits of using them?

990

---

How can we remove the duplicates from flat file source?

948

---

Is it possible to define a single node as a Gateway node as well as worker node?

1058

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1874

---

Briefly define reusable transformation?

1075

---

Explain your project of banking domian.

1606

---

explain one complex mapping with logic? sales project?

6593

---

where to store informatica rejected data?

1046

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1085

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1220

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1113

---