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 |
tell me 7.x and 8.x diferrencess(but not transformations)
how to insert header after each group.
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
what are the types of facts with Examples?
What is the need of etl tools?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.
How can you complete unrcoverable sessions?