Write the unconnected lookup syntax and how to return more than one column.
how will compare two mappings in two different repository?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
How do you do error handling in Informatica?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
What is xml source qualifier transformation in informatica?
what is the difference between stop and abort
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
Explain scd type 3 through mapping.
How can you increase the performance in joiner transformation?
how to get max value record into one target and remaining records into another target?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
What are the different types of transformation available in informatica.