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
- 7216 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 |
Explain the types of lookup transformation?
Can you generate reports in Informatcia?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
What is data quality? How can a data quality solution be implemented into my informatica transformations, even internationally?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
how to remove staging area
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is a pre-defined event and user-defined event?
Differentiate between a repository server and a powerhouse?
Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.
Teradata 
