How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.
- 1 Answers
- 2658 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / isha
We can use contraint based loading in that case and after loading all the dimensions table we can load the data into fact table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Separate from an archive server and a powerhouse?
What are the differences between a connected lookup and unconnected lookup?
What is workflow? What are the components of the workflow manager?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the types of caches in lookup? Explain them.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is a transaction control transformation?
pmscmd startworkflow -sv
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to call shell scripts from informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
can any one give some examples for pre sql and post sql(Except dropping and creating index).
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Can u generate reports in Informatica?
