Answer Posted / swetha
Use lookup transformation in u'r mapping to lookup data in a
relational table, view, synonym.
Informatica server queries the look up table based on the
lookup ports in the transformation. It compares the lookup
transformation port values to lookup table column values
based on the look up condition.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
generate date / time dimension in informatica
What is the Rank index port in Rank transformation?
What is the use of code page?
What is the use of an aggregator cache file?
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 .
Parameter and variable differences
Explain in detail about scd type 1 through mapping.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
How an expression transformation differs from aggregator transformation?
Mention some types of transformation?
What is the maplet?
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
What is rank transformation?
What is sorter transformation?
What is decode in static cache?