Answer Posted / giri
Staging area is collection of database. It is temporary storage
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
in reporting we add some new objects,how we get the count of the newly added objects to the report
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
differences between service based and product based?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the reusable transformations?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Enlist the differences between database and data warehouse.
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How many numbers of sessions can one group in batches?
Which transformation is needed while using the Cobol sources as source definitions?
How do you load alternate records into different tables through mapping flow?
What do you understand by a term domain?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is enterprise data warehousing?
