hi,this is satheesh working as pl/sql resource in MNC.i
just wanna switch to informatica.Could you please let me
know what is the best way to learn informatica.what are the
best coaching centres available in chennai?Is there any
coaching centre will give me a real time experience?
informatica
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain joiner transformation in informatica
What are the different types of olap? Give an example?
Different qualification between a related rotate toward the sky and isolates look upward?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
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
For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL
If informatica has its scheduler why using third party scheduler?
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
what is the exact meaning of domain?
How many repositories can we create in Informatica?