Answer Posted / bharu_295

hi cdc stands for capture data change.

it is done by using incremental loading of the source data.

ex: in source take a column modified date

in mapping take sysdate as one column and get data with modifieddate>sysdate. condition.

How is union transformation utilized?

1060

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1129

---

What can we do to improve the performance of informatica aggregator transformation?

1142

---

Define pmcmd command?

1105

---

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.

2901

---

How do you use reject loader.

2651

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1382

---

What is the function of aggregator transformation?

1135

---

To import the flat file definition into the designer where should the flat file be placed?

1104

---

What is the benefit of partitioning a session?

1235

---

where to store informatica rejected data? How to extract the informatica rejected data?

1054

---

What is the procedure for creating independent data marts from informatica 7.1?

1118

---

How are the sources and targets definitions imported in informatica designer?

1170

---

How can you validate all mappings in the repository simultaneously?

1425

---

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2094

---