Answer Posted / srinivas

hi dahrmendra,

HOw can you join two pipeline or two branches of single
pipeline to single target.

even in place of tgt if you have any active or passive t/r
is presented tat mapping wouldnt be valid.but yes in place
of tgt you can use any multi input group t/r and connect it
to tgt then its valid

What is a sorter transformation?

1102

---

Design a mapping to load a target table with the following values from the above source?

1349

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

2341

---

What is the use of code page?

1097

---

What are the components of workflow manager?

1105

---

Write the unconnected lookup syntax?

1084

---

How many types of sessions are there in informatica.please explain them?

1170

---

Which development components of informatica have the highest usage?

1048

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2862

---

what is size of u r database?

2311

---

What is a transaction control transformation?

1210

---

Explain sessions and how many types of sessions are there?

1011

---

What is the way to execute pl/sql script using informatica mapping?

1612

---

Why update strategy and union transformations are active?

1046

---

What is the scenario which compels informatica server to reject files?

1073

---