when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
5 16423(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
1 8013i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
HP,
2 8287hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
1 5251Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
2304Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
IBM,
1 6976i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
3 13165can any one explain about dataflow in the informatica project for bank domain....thanks is advance
IBM,
10684what is service oriented architecture in Informatica 8 version
Cap Gemini, IBM, Systech, TCS,
1 10588we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
8 12328Post New Informatica Questions
can we override a native sql query within informatica? Where do we do it?
What is a joiner transformation?
Briefly define reusable transformation?
What is a surrogate key?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the popular informatica products?
Why do we need informatica?
How does a sorter cache works?
How can we create index after completion of load process?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What the difference is between a database, a data warehouse and a data mart?
how many types of dimensions are available in informatica?
How to elaborate powercenter integration service?
Target increases every day even though no new record was inserted