Answer Posted / vignesh muralidharan
The datas are kept in the data base
through the slowly changing dimension process.There are
three types in slowly changing dimensions:
type1,type2.type3.
| Is This Answer Correct ? | 12 Yes | 7 No |
Post New Answer View All Answers
Briefly describe lookup transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
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 are mapplets? How is it different from a Reusable Transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
How do you use reject loader.
What is an aggregator transformation?
What is xml source qualifier transformation in informatica?
What is a sorter transformation?
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 the session task and command task?
What is the advantage of informatica?
What is pmcmd command?
Write the different tools in the workflow manager?