How can u work with remote database in informatica?did you
work directly by using remote connections?
Answers were Sorted based on User's Feedback
Answer / swetha
To work with remote datasource u need to connect it with
remote connections. But it is not preferable to work with
that remote source directly by using remote connections
.Instead u bring that source into U r local machine where
informatica server resides. If u work directly with remote
source the session performance will decreases by passing
less amount of data across the network in a particular time.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rekha
By using UNIX command i.e
$ ftp m get filename we can import the remote database
into our local system.
Is This Answer Correct ? | 0 Yes | 0 No |
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
Briefly define a session task?
Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project
can v update d records in target using update stargey without generationg primary key ? explain
Differentiate between mapping parameter and mapping variable?
how will compare two mappings in two different repository?
Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
plz plz plz send client names and project names in informatica?
What is the difference between lookup override and souce qualifier override ?