Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 7235 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradeep
We wil go for left outer join on the lookup table in the
source qualifier sql override so that it wil return both the
records.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?
Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks
I want load the data into target with out 1st and last record.
Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek
How can one identify whether mapping is correct or not without connecting session?
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
How can you define a transformation? What are different types of transformations in Informatica?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
How to join three sources using joiner?
How many cubes create from a single model?
how can we run workflow with pmcmd?
Teradata 
