Is scd logic we have lookup right to compare the values with
source and target,instead of lookup can u have any
transformation or any way to do this?
Answers were Sorted based on User's Feedback
Answer / naga
We can write Left outerjoin with the target in Source
Qualifier itself or if ur src is file & target is Table
then using Joine(Left outer) can get the new rows loaded
into target
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / itsranjan
Hi, Joiner transformation can do the same job what lookup
does in SCD.
Is This Answer Correct ? | 1 Yes | 2 No |
What is fact table? Explain the different kinds of facts.
Label in Informatica. How to remove existing Label.
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
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.
Explain sessions and how many types of sessions are there?
Different sorts of metadata that stores in the storage facility?
What are the different options used to configure the sequential batches?
What is informatica?
what is curr val use for in sequence generator?
How to send duplicates to one target and unique rows to one target?target is empty
what is incremental loading ?
12 Answers CTS, IBM, Oracle, TCS,
Which transformation is needed while using the Cobol sources as source definitions?