Write the unconnected lookup syntax and how to return more than one column.
No Answer is Posted For this Question
Be the First to Post Answer
What is persistent lookup cache?
On a day i load 10 rows in my target and on nextday i get 10 more rows to add in target. But out of 10 - 5 records are send them to target?how i can insert the remaining records
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
Aggregator 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
Which is costliest transformation? costly means occupying more memory?
What is mapping debugger?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
What is the default source option for update stratgey transformation?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?