On lookup on any table we can get only a)any value or b)last
value but if i need both duplicate values How can i achieve?
Answer Posted / suresh
actually on lookup two ways we can put the values normally
we put a anyvalue(if you want to both duplicate values).
when we use SCD type 2 its must and should put on last value
into the look up Bcoz it should store the history.
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Why do you use Mapping Parameter and mapping variable?
How to create a non-reusable instance of reusable transformations?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is the surrogate key?
In warehouses how many schemas are there?
What are the advantages of informatica?
To import the flat file definition into the designer where should the flat file be placed?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is intricate mapping?
Enlist the various types of transformations.
Write the program through which the records can be updated?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is a code page?
What could be the possible resons of locks by user?