Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nagendra phani
Data Mart is the subset of datawahehouse and it is used to
store the data department wise.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
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?
Where do we use mapping variables in informatica?
What is an Integration service in Informatica?
What is the difference between informatics 7x and 8x and what is latest version?
what is diff b/t sorter t/r and agg have the option sorter property...
What are the mapping parameters and mapping variables?
Define enterprise data warehousing?
Slowly changing dimensions, types and where will you use them
How to use pmcmd utility command?
What is the difference between source qualifier transformations source filter to filter transformation?
What are the tasks that can be performed using sq?
What is an active transformation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How many ways are there to create ports?
