Interested to Buy Any Domain ? << Click Here >> for more details...
What is informatica?
What exactly are the practical uses in real world
- 2 Answers
- 6037 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Informatica is an ETL tool used in DWH concept.
It keeps historical data. So all those organizations who wants
to keep their all data i.e. updated and historical too(not
only to update data and deleting the old data) can use it.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / jagadeesh gaddam
Informatica is an etl toll .it loads the data from various oltps like homogenius as well as hetrogeniuse.based on this loadig data we can genarate the reports what we exactly want for our business development and anyalise the business and take the right decissions
| Is This Answer Correct ? | 0 Yes | 0 No |
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
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.
how we can load rejected record's at run time?(not through bad files)
What are the mapping parameters and mapping variables?
How do you implement configuration management in Informatica?
what is diff between grep and find
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
how do u fnd the duplicate rows and how to delete the duplicate rows?
How can you access the remote source into your session?
What is intricate mapping?
Teradata 
