Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / maruthi
union-can join two tables without common port
joiner-can join any two hetrogenous sources,but common port
is necessary.
lookup-we can join two tables by using sql over-ride,apart
from that we can check wether the row is already existing
or not.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What does role playing dimension mean?
Explain lookup transformation is active in informatica
Is it possible to use a client with different version than that of its Informatica server?
What is session task and command task?
Tell me about MD5 functions in informatica
Name the different lookup cache(s)?
How union transformation is used?
What all are steps in up gradation of Informatica server?
How to load a Dimension ? and how to load a fact table?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
can u give example for factless fact table
What is a surrogate key?
