In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?

Answer Posted / har

use dynamic lookup

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

While migrating the data from one environment to another environment how would you manage the connections?

627


What are the modules in Power Center

1240


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

554


Explain the code page compatibility?

645


How to extract the informatica rejected data?

757






How might one distinguish in the case of mapping is right or not without associating session?

642


What is rank transformation in informatica

693


have u done any performance tuning? how u ll do?

1862


Why union transformation is an active transformation?

659


What are the features of complex mapping?

650


Enlist the tasks for which source qualifier transformation is used.

594


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 .

1474


Under which circumstances, informatica server creates reject files?

595


Which transformation should we use to normalise the COBOL and relational sources?

748


Explain the tuning lookup transformation - informatica

615