Answer Posted / ganesh

write a query like

select * from <table_name> order by where sal=(select max(sal) from <table_name>)

What is a pre-defined event and user-defined event?

1085

---

Scheduling properties,whats the default (sequential)

2014

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1116

---

What is option by which we can run all the sessions in a batch simultaneously?

1196

---

What is rank transform?

1061

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1694

---

What is rank transformation?

1037

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1250

---

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?

1559

---

where to store informatica rejected data?

1141

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2072

---

Slowly changing dimensions, types and where will you use them

1774

---

What do you understand by term role-playing dimension?

1121

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1821

---

Define mapplet?

1060

---