Answer Posted / amit
fact table is collection of all facts in the dimension
facys is nothing but quantitative data
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
Can you generate sequence numbers without using the sequence generator transformation?
Why update strategy and union transformations are active?
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 are the components of Informatica? And what is the purpose of each?
Explain the aggregator transformation?
Explain lookup transformation in informatica
What is a joiner transformation?
What are the different options available for update strategy?
What is powercenter on grid?
Global and Local shortcuts. Advantages.
Why do you use Mapping Parameter and mapping variable?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Explain in detail about scd type 1 through mapping.
What do you mean by blocking transformation?
How do you manage the Parameter files while migrating your data from one environment to another environment?