Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
7 14707What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
2 7322Aggregator transformation is having fields say a,b,c,d,e group by is enabled on a,b,c with sorted input,How the aggregator transformation process the i/p data?or in which way i/p comes to agg transformation
1 4880One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
2213following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
4 8189source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
4 9446Post New TCS Informatica Interview Questions
what is sweeper in Rails?
How do I get a list of all files (and directories) in a given directory in Python?
What is the one-way mode in wcf?
What do you mean by a scala map?
Why do we need ado.net?
What is row and column in excel 2007?
Why we use chaining in jquery?
What is meant by the statement that 8085 is a 8 bit microprocessor?
What are the Inheritance types?
Write short notes on Post transplant immunosuppression?
Q.3. One of the serious problems faced by the Public Enterprise Management in our country is that: (a). Very little managerial autonomy. (b). More bureaucratization (c).Excessiveinvestment. (d). Excess of accountability.
What is metallic fibers?
How Many Types Of Streams Are Present In Node?
What are javascript closures?
Explain PI - Process Integration?