How You Pull the records on daily basis into your ETL Server.
Answer Posted / munireddy
uning incremental/delta/cdc..
for this we have so many logics some of them are..
using mapping level variable
using control table and ....
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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?
what is size of u r database?
can we override a native sql query within informatica? How do we do it?
Define mapping and session?
What is the meaning of decode in informatica?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
can we override a native sql query within informatica? Where do we do it?
Explain informatica architecture - version 8 / 9
What are the new features of informatica 9.x in developer level?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
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?
What is workflow? What are the components of the workflow manager?
Explain the difference between a data warehouse and a data mart?
Explain the informatica workflow?
What is the maplet?