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
- 13170 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
How do you change a non-reusable transformation to reusable transformation?
What do you mean incremental aggregation?
Explain joiner transformation in informatica
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How do you load unique records into one target table and duplicate records into a different target table?
Have you worked with/created Parameter file
Explain the features of connected and unconnected lookup.
How do we call shell scripts from informatica?
What are the types of caches in lookup? Explain them.
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the new features of Power Center 5.0?
Informatica Checkpoints
how to create user defined function (udf) in informatica
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
