Answer Posted / james

whatever data u want to delete from target table,simply go
with truncate option.

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?

1677

---

What are Dimensional table?

1057

---

Where is metadata stored?

1113

---

r u done any partitions in ur project?

1827

---

Global and Local shortcuts. Advantages.

2034

---

what is song in infrmatica...?

2237

---

Explain what are the different versions of informatica?

1099

---

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.

2860

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1076

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1914

---

What happens when a session fails and you click on recover?

1120

---

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

1076

---

Sequence generator, when you move from develoment to production how will you reset

2040

---

What is dimensional table?

1066

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2077

---