Answer Posted / venubyna1

Asession configure for push down optimization to Increase
the session performance.
The I.S Analyze the mapping and T/r logic and determine T/r
logic it ll send to the source or Tager data base
I.S is convert the T/r logic into SQL then send to the data
base server
there r 3 types
1. Source side push down
2.Target side push down
3.fullside push down

Separate from an archive server and a powerhouse?

491

---

Can you generate sequence numbers without using the sequence generator transformation?

595

---

What is a code page?

710

---

How do you migrate data from one environment to another?

641

---

What is update strategy transform?

567

---

---

How to create the source and target database connections in server manager?

622

---

What is the use of code page?

602

---

How you can differentiate between connected lookup and unconnected lookup?

606

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1234

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

1802

---

How to load data in informatica ?

568

---

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?

1042

---

Write the advantages of partitioning a session?

741

---

server hot-ws270 is connect to Repository B. What does it mean?

1853

---

How to do the error handling of if ur source is flatfiles?

1506

---