Interested to Buy Any Domain ? << Click Here >> for more details...
i want to load data in to two targets..one is dimension
table and the other is fact table?how can i load ata a time
- 3 Answers
- 12979 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / amedela chandra sekhar
use surrogate pipeline technique first data loaded into dimension table ,then loaded into fact fable with primary and foreign key technique b/w dimension and fact table.
use lookup t/r.........
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is Cognos script editor?
Under what condition selecting sorted input in aggregator may fail the session?
How to update or delete the rows in a target, which do not have key fields?
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 is the benefit of partitioning a session?
What is a surrogate key?
What is joiner change?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
How does a rank transform differ from aggregator transform functions max and min?
What is the advantage of informatica?
Differentiate between joiner and lookup transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is a grid in Informatica?
Make a note of the quantity vaults made in informatica?
Is it possible to create multiple domains on a single Informatica server?
