What is the role of informatica in project ?Like i showed
financial projects?
Answer Posted / 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 |
Post New Answer View All Answers
What is workflow? What are the components of workflow manager?
What is a pre-defined event and user-defined event?
What are the different types of olap? Give an example?
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 to open an older version of an object in the workspace?
In how many ways we can create ports?
How many types of sessions are there in informatica.please explain them?
What is status code in informatica?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are pre and post-session shell commands?
scenario where i can use only concurrent execution of workflow.
What are junk dimensions?
update strategy transformation in informatica
What is meant by incremental aggregation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.