Interested to Buy Any Domain ? << Click Here >> for more details...
What is informatica?
What exactly are the practical uses in real world
- 2 Answers
- 6081 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 |
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
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?
If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
how i will stop my workflow after 10 errors
Which transformation is needed while using the Cobol sources as source definitions?
Explain Dataware house architecture .how data flow from intial to end?
How can u work with remote database in informatica?did you work directly by using remote connections?
Clarify the utilization of aggregator cache record?
how do u tune queries?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
Teradata 
