When will you use SQL override in a lookup transformation?
Answer / vanita
For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause
Is This Answer Correct ? | 10 Yes | 0 No |
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
what is mapping override?
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
How many mapplets u have created? and what is the logic used
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
What are the reusable transformations?
Label in Informatica. How to remove existing Label.
What are the types of groups in Router transformation?
After we make a folder shared can it be reversed?Why?
What is the filename which you need to configure in UNIX while installing infromatica?
What are the challenges you have faced in your project?
Can we create a Integration service without a Repository service and vice versa?