What is the role of informatica in project ?Like i showed
financial projects?
- 1 Answers
- 2749 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer / sudhansu
Informatica is an ETL(Extract transformation Load) tool , which loads data into a centered area called Data mart or DW. Business can analyze data using a reporting tool and make decision for improvment of business.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to update or delete the rows in a target, which do not have key fields?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
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
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
How can u work with remote database in informatica?did you work directly by using remote connections?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
What is Session and Batches?
What are two types of processes that informatica runs the session?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
where actually the usage of push down optimization happens...
explain about unit testing? in real time?
Teradata 
