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 is rank transformation?
What is data movement mode in Informatica and difference between them?
What is workflow? What are the components of the workflow manager?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Explain pmcmd command usage in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is decode in informatica?
What is joiner transformation in informatica?
tell me the rules and responsblites in our project(my project is development)
Write the different tools in the workflow manager?
Write the advantages of partitioning a session?
Explain the features of connected and unconnected lookup.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Which development components of informatica have the highest usage?