Answer Posted / pradeepreddygade
using Mystery Dimension you are maintaining the junk data in
your Project. Mystery Dimension are also known as Junk
Dimensions
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain why we use partitioning the session in informatica?
What is update strategy transform?
Can we change Dynamic to Static or Persistent cache? If so what happens?
How might one distinguish in the case of mapping is right or not without associating session?
In development project what is the process to follow for an etl developer from day1
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
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
Explain the types of lookup transformation?
Difference between Target-based loading and constraint-based loading?
What is a joiner transformation and why it is an active one?
what is the size of your data warehousing?
Mention few power centre client applications with their basic purpose?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Whats the difference between informatica powercenter server, repositoryserver and repository?