Answer Posted / ramesh.b

hi,
normally router means multiple targets...take 2 groups first group condition isnull and second group condition not isnull.first group gives the null values and second group gives the non null values.

source-->sq-->expression-->router-->2 targets

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1058

---

What is the difference between Active and Passive transformation?

1145

---

Mention few advantages of router transformation over filter transformation.

1019

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

963

---

update strategy transformation in informatica

1060

---

What is decode in static cache?

1166

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1503

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1965

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2153

---

What is the function of look up transformation?

1121

---

How to Create a folder using pmrep command?

1169

---

What is the surrogate key?

1248

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2408

---

What are active and passive transformations?

1079

---

How might you approve all mappings in the archive all the while?

1011

---