GeekInterview.com
Submitted Questions

How do you change the transformation?

Asked By: sunitha ravula | Asked On: Jun 10th, 2011

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?

Answered by: sppavankumar on: 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?

Asked By: sunitha ravula | Asked On: Jun 10th, 2011

Answered by: RSUDHAKARREDDI on: 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 ?

Asked By: sunitha ravula | Asked On: Jun 10th, 2011

One source is flat file and other source is Oracle, then how do you do the mapping?

Answered by: sppavankumar on: 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 ...

Answered by: xitij7185 on: Jun 13th, 2011

with joiner transformation .

How to read the data from XML and flat files in Informatica?

Asked By: sunitha ravula | Asked On: Apr 25th, 2011

Answered by: MAHESH MANAM on: 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...

Answered by: dileep671 on: 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?

Asked By: sunitha ravula | Asked On: Apr 5th, 2011

Answered by: k.shankar on: 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

Asked By: sunitha ravula | Asked On: Mar 31st, 2011

Hi,how to pull the data from XML and flat files in Informatica?How to pull the data from materialized view in Informatica?

Interview Question

 Ask Interview Question?

 

Career Counselling

 Have Career Question?

 Ask Chandra

 Ask Only Career questions.

Follow us: