What is informatica?
What exactly are the practical uses in real world
Answer Posted / niharika panda
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 |
Post New Answer View All Answers
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
in reporting we add some new objects,how we get the count of the newly added objects to the report
Where is metadata stored?
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?
Slowly changing dimensions, types and where will you use them
my source is junk data how will u remove that junk data by using unix please any one replay me
Explain scd type 3 through mapping.
What is workflow? What are the components of workflow manager?
Explain constraint based loading in informatica
What are multi-group transformations?
Did u used latest transformations of 8.6.0? for what?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Does an informatica transformation support only aggregate expressions?
In development project what is the process to follow for an etl developer from day1
Can we override a native sql query within informatica?