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
Answer Posted / g. manthiramoorthy
Using dynamic lookup, you can load both simultaneously.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
What are the different versions of informatica?
Mention some types of transformation?
without table how to come first record only in oracle?
What does “tail –f” command do and what is its use as an Informatica admin.
What are the new features of informatica 9.x in developer level?
Different circumstance which drives informatica server to expel records?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How is union transformation utilized?
Explain about Informatica server process that how it works relates to mapping variables?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
how many types of dimensions are available in informatica?
Repository user profiles
How to use pmcmd utility command?
What is an expression transformation in informatica?
I have a flat file, want to reverse the contents of the flat file