How can you access the remote source into your session?
Answer / swetha
Relational source: To acess relational source which is
situated in a remote place , you need to configure database
connection to the datasource.
FileSource : To access the remote source file you must
configure the FTP connection to the host machine before you
create the session.
Hetrogenous : When your maping contains more than one
source type,the server manager creates a hetrogenous session
that displays source options for all types.
| Is This Answer Correct ? | 0 Yes | 0 No |
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
design of staging area?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?
What is dimensional table?
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Can you create a flatfile target
What is the use of incremental aggregation?
Does Facttable Normalized or Denormalized?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project