Interested to Buy Any Domain ? << Click Here >> for more details...
After a load is done to my target table, I need to insert a
last row, which might be formed at some expression
transformation and brought to target. Do I have to have
separate mapping to be run after the 1st mapping? Or in a
single mapping how to achieve this?
- 3 Answers
- 8748 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sp
This can be done by defining the target load plan in the developer. You can define two instance of the target and use the same SQ with Expression to load the last row to the second instance of the target. The second instance will be set to load at last in the load plan.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How do we call shell scripts from informatica?
Differentiate between joiner and lookup transformation?
explain about unit testing? in real time?
Explain the mapping variable usage example in informatica
Explain the types of lookup transformation?
What is the need of an ETL tool?
How you can differentiate between connected lookup and unconnected lookup?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What is native users?
What is difference between a gateway node and worker node?
complex mapping ur project u r invlve can u explain and give real time example give me ?
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?
In warehouses how many schemas are there?
Name the different lookup cache(s)?
