How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
- 3 Answers
- 27450 Views
- I also Faced
- E-Mail Answers
Answer Posted / kalyan
Using Normalizer T/R we can achieve this; Horizantal
Pivoting i.e Coverting Single horizantal record into
Multiple vertical records. Even reverse logic i.e; Vertical
Pivoting also possible using the Normalizer T/R.
Please correct me if I am wrong !!
| Is This Answer Correct ? | 10 Yes | 17 No |
Post New Answer View All Answers
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is blocking transformation?
Can you use flat files in Mapplets.
Performance tuning( what you did in performance tuning)
What is an aggregator transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
What are the differences between a connected lookup and unconnected lookup?
Mention a few design and development best practices for informatica?
What is persistent lookup cache?
Can we override a native sql query within informatica?
Briefly define reusable transformation?
Differentiate between joiner and lookup transformation?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is depict expression change?
