How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
No Answer is Posted For this Question
Be the First to Post Answer
what is incremantal aggregation?
what is unit testing?tell me proceedure
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
How will you combine 3 different sources with a single source?
Which transformation should u need while using the cobol sources as source defintions?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
I have source like this 1:2;3. so i want to load the target as 123
Can I create one wrkflw which will run different wrkflws on schedule time?
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000