how to get the data from the client machine and how to get server location data to client loction
can any one explain bit deep please..!

Answer Posted / moorthy g

Through Incremental Loading
(using mapping parameter)
so-sq(use SQL Override)-exp(SetMaxVaribale($$date, tr_date))-tar

Is This Answer Correct ?    1 Yes 10 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why is sorter an active transformation?

863


Different sorts of metadata that stores in the storage facility?

757


How to partition the Session?

824


What is the way to execute pl/sql script using informatica mapping?

1206


scenario where i can use only concurrent execution of workflow.

2760






Differentiate between Load Manager and DTM?

1865


Can we create a node as a gateway node and the same node can be assigned to a grid?

834


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

738


Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

885


Target increases every day even though no new record was inserted

1319


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1875


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5323


Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

826


While migrating the data from one environment to another environment how would you manage the connections?

846


How do we call shell scripts from informatica?

763