How do you change the transformation?
On one day there are 10 cities and the other day 5 more cities gets added? Then how do you change the transformation? What do you do?
Difference between source qualifier and normalizer?
Source qualifier transformation extract data from only files and rdbms.but normaliser transformation used to extract data from COBOL files.
How would you do mapping with flat file and Oracle as source ?
One source is flat file and other source is Oracle, then how do you do the mapping?
There are two possible ways of doing it: 1) Both used in a single mapping with single pipeline(Joiner can be used, in order to join both the source in the mapping) 2) Use two different pipelines in a ...
with joiner transformation .
How to read the data from XML and flat files in Informatica?
From flat file you use the following wys: --> In source analyzer you can create file by manually -->you can import file -->you can use any of the flat file and give session properties in that correc...
Go to Source analyzer , then import XML Source, a wizard opens up.. select the Schema Definition (XSD) of th XML file
When you run the session, give the XML file name and XML file directory path.
How to extract data from XML and flatfiles in Informatica?
When importing the source definition, the file must be in a directory local to the client machine. In addition, the Integration Service must be able to access all source files during the session. ...
Hi,how to pull the data from XML and flat files in Informatica?How to pull the data from materialized view in Informatica?
If there is change in the data, there is no need to go for changing of the transformation. Instead you can insert/update the incremental data.
Please elaborate the question if not answered.