How do you implement scheduling in Informatica?
We can use Scheduler option in Workflow to schedule the entire mapping.
Also, if we are using any central scheduler tool for this purpose, we can create a command file with PMCMD to run the workflow and schedule execution of that command file in a scheduler.
| Is This Answer Correct ? | 2 Yes | 0 No |
hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd
Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?
How many input parameters can exist in an unconnected lookup?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
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 the procedure and whar t/r's are involved and what is the mapping flow
What is union transformation?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
Where do you create/define mapping parameter and mapping variable?
write a query to retrieve the latest records from the table sorted by version(scd)
Can we update a target table (without primarykey) by using update strategy transformation?