If no. of source columns is changing every time (First time
it is 10 next time it is 20 so on). How to deal with it
without changing mapping?

Answer Posted / sathish rajaiah

Create source defination with maximum (depends on the max
numbers of columns u get in the source) number of fields
and use that in the mapping.
ex: create source defiantion with 20 fields and use this in
mapping this wil handle source comes with columns btween 1
to 20.

Note : Above wrks only for flat file sourcse not fr RDBMS
sources

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Different sorts of metadata that stores in the storage facility?

796


What is the session task and command task?

804


What is Cognos script editor?

3970


Explain joiner transformation in informatica

909


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1811


What is powercenter on grid?

956


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

894


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1769


How do you update the records with or without using update strategy?

900


can we override a native sql query within informatica? Where do we do it? How do we do it?

846


What does update strategy mean, and what are the different option of it?

863


What is data transformation manager process?

840


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1776


What is parallel processing in informatica?

1323


What is a grid in Informatica?

850