What is degenerated dimention table?

Answer Posted / sujana

it is generated at runtime..acts as pk in fact table..

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is metadata stored?

623


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

631


What are the types of caches in lookup? Explain them.

553


What is powercenter on grid?

699


What are the different versions of informatica?

685






What are session parameters ? How do you set them?

1379


How are the sources and targets definitions imported in informatica designer?

672


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

6485


Write the different tools in the workflow manager?

577


What is rank transform?

603


Design a mapping to load a target table with the following values from the above source?

883


What is the different lookup cache(s)?

616


write a query to retrieve the latest records from the table sorted by version(scd)

635


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1635


Design a mapping to load the cumulative sum of salaries of employees into target table?

900