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 |
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
How informatica recognizes mapping?
difference between informatica 8.1.1 and 8.6
hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you
What are the differences between joiner transformation and source qualifier transformation?
when we use dynamic lookup,if condition matches what will be the o/p?
where to store informatica rejected data? How to extract the informatica rejected data?
what is the -ve test case in your project.
What are the components of the workflow manager?
How to generate sequence numbers?