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 15039What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
2 7465Aggregator 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 4988One 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?
2268following 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 8376source 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 9637Post New TCS Informatica Interview Questions
Explain sqlconnection object?
What is the chromosome number of Ginkgoes?
What are the major differences between Thread and Process?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How do Merge subscriptions work?
What do you understand by unique key?
Can we share a process between windows services?
How to initialize a driver in codeigniter?
Is array an object javascript?
What are catalog tables in db2?
How a modifier is similar to mutator?
What is Overfitting and Underfitting and how to combat them?
What are different types of jit ?
Why is it called excel?
What do you mean by a file path?