Answer Posted / pooja

hi all,
suppose 4 emp geting same sal as 4000... select * from emp
where sal=4000 and/having rowid=3

if we have a delimiters at unwanted places in a flat file how can we over come those.

2094

---

What is meant by target load plan?

1032

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4152

---

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

---

What are the tasks that can be performed using sq?

1146

---

which one is better performance wise joiner or look up

1155

---

How can you increase the performance in joiner transformation?

1250

---

How do you load only null records into target? Explain through mapping flow.

2077

---

What is incremental aggregation?

1138

---

Mention a few design and development best practices for informatica?

1047

---

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

1188

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2374

---

How to generate or load values in to the target table based on a column value using informatica etl tool.

1120

---

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

1197

---

What are ETL Tools?

1177

---