i have two source data there is no pk,fk how to join the
two sources
Answer Posted / prathap
if the two sources or coming from different sources then we
use joiner transformation and add a dummy prot
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Differentiate between router and filter transformation?
What are the advantages of informatica?
How to delete duplicate row using informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the measure objects?
How to elaborate powercenter integration service?
What is meant by active and passive transformation?
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
Does an informatica transformation support only aggregate expressions?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What all are steps in up gradation of Informatica server?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain lookup transformation is active in informatica
Do you find any difficulty while working with flat files as source and target?
What do think which one is the better joiner or look up?