-
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?
sppavankumar
- Jul 18th, 2011
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. -
Difference between source qualifier and normalizer?
shambhu
- Feb 25th, 2016
1. SQ is used to represent the data from sources (relational, flat file) which Integration service can read
2. Normalizer is used as a source qualifier when we have Cobol source (Denormalized), which SQ can not read
3. Normalizer can be used for transposing columns into rowsRSUDHAKARREDDI
- Jun 20th, 2011
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?
sppavankumar
- Jul 18th, 2011
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 ...
-
How to read the data from XML and flat files in informatica?
MAHESH MANAM
- Aug 16th, 2012
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...
dileep671
- Aug 3rd, 2012
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?
k.shankar
- Apr 7th, 2011
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. ...
-
How to pull the data
Hi,How to pull the data from XML and flat files in informatica?How to pull the data from Materialized view in informatica?
