Interested to Buy Any Domain ? << Click Here >> for more details...
How can a Lookup with Dynamic Cache be replaced in a
mapping? Explain.
- 2 Answers
- 7776 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / abhishek.x.upadhyay
A lookup with Dynamic cache can be replaced by an SQL
override query in the transformation itself which will run
each time there is load of data during the run of the
Workflow.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Please let me know how to make encryption and decryption with example?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the tuning techniques you applied during your last project
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How does a rank transform differ from aggregator transform functions max and min?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What could be the possible resons of locks by user?
write a query to retrieve the latest records from the table sorted by version(scd)
What is a pre-defined event and user-defined event?
Explain the aggregator transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Is it possible to define a single node as a Gateway node as well as worker node?
Explain Dataware house architecture .how data flow from intial to end?
