Interested to Buy Any Domain ? << Click Here >> for more details...
How to load dimension and fact in same mapping at same
time.explain me the logic used for that scenario.
- 1 Answers
- 3579 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
What is sorter transformation?
Explain lookup transformation is active in informatica
Define update strategy?
Explain the difference between mapping parameter and mapping variable?
permutations of mapplet
What is workflow? What are the components of workflow manager?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
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?
What is mapping debugger?
lookup transformation with screenshots
In how many ways we can create ports?
How to load last n records of file into target table - informatica
What will be the approach?
Briefly explain the aggregator transformation?
What is resilience time?
