Why use the lookup transformation ?

Answer Posted / rekha

1. GET A REALTED VALUE
2.UPDATE SLOWLY CHANGING DIMENSION
3.PERFORM CALCULATIONS

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are active transformations.

1191


What is a node in Informatica?

633


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?

600


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

627


Make a note of the quantity vaults made in informatica?

561






What is the difference between writing a joiner query in ANSI style and THETA style?

1925


What is union transformation in informatica?

701


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1741


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2073


What is Data Caches size?

658


What is primary and backup node?

705


What are the restrictions of union transformation?

582


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 .

1473


Is it possible to create multiple domains on a single Informatica server?

760


What is informatica worklet?

613