i have two source data there is no pk,fk how to join the
two sources
Answer Posted / chandrababu.sarupuru
To join these sources we will use SQL Override function in
Source qlalifier transformation....
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is the procedure for creating independent data marts from informatica 7.1?
Different circumstance which drives informatica server to expel records?
Explain in detail about scd type 1 through mapping.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is meant by incremental aggregation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is InformaticaPowerCenter?
What is a joiner transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
What is a repository manager?
what is $$$$?
Briefly describe lookup transformation?
What is standalone command task?
can any one give some examples for pre sql and post sql(Except dropping and creating index).