Answer Posted / gagan

Suppose first table as test created below...

create table test
(
city varchar2(50),
gender varchar2(50),
nmbr varchar2(50)
)

and keep all data in it as mentioned and then try to run
this query...


select a.city, a.nmbr as male, b.nmbr as female
from test a, test b
where a.gender = 'male' and b.gender = 'female' and b.city
= a.city

What is a rank transform?

1146

---

What is a difference between complete, stop and abort?

1125

---

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?

2310

---

Differentiate between sessions and batches?

1068

---

Explain how to import oracle sequence into informatica?

1071

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1989

---

lookup transformation with screenshots

4050

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2071

---

Define update strategy?

1315

---

What is rank transform?

1061

---

What is depict expression change?

1192

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5789

---

What is an expression transformation?

1077

---

Is stop and abort are same in informatica?

1048

---

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?

1019

---