If the source has duplicate records as id and name columns,
values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as
1 a+b+c or 1 a||b||c, what transformations shd be used for
this?
Answer Posted / saritha
you can use normalizer or expersion transformation.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
What are roles and groups and benefits of using them?
What is workflow? What are the components of workflow manager?
Whats the difference between informatica powercenter server, repositoryserver and repository?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
How to create or import flat file definition in to the warehouse designer?
What are the tasks that can be performed using sq?
expain about the tune parameters?
what is INFORMATICA TESTING process
Explain the different lookup methods used in informatica?
what is the size of your data warehousing?
What is Data Caches size?
In warehouses how many schemas are there?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.