Interested to Buy Any Domain ? << Click Here >> for more details...
How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?
- 3 Answers
- 28915 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
Define mapplet?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Where are the source flat files kept before running the session?
What is a joiner transformation and why it is an active one?
How many input parameters can exist in an unconnected lookup?
What is blocking transformation?
What is workflow monitor?
What are the main features of Oracle 8i with context to datawarehouse?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Different circumstance which drives informatica server to expel records?
Clarify the utilization of aggregator cache record?
Explain lookup transformation is active in informatica
What happens when a session fails and you click on recover?
What is different between the data warehouse and data mart?
design of staging area?
