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 / arnab
This should not happen when executing a datawarehousing
project , This reflects poor design and poor visualisation
of the requirements
The safest way to handle this is re-import the source
definition, someone suggested create a source with the
maxinmum number of columns , there is something called
quality of code and if someone codes like this it is really
a bad example of informatica coding
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the different lookup cache(s)?
What are the components of Informatica? And what is the purpose of each?
What is a sequence generator transformation?
How can you differentiate between powercenter and power map?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Explain what is informatica metadata and where is it stored?
How many transformations can be used in mapplets.
What is a connected transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the status code in stored procedure transformation?
How many ways are there to create ports?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How to Create a folder using pmrep command?
What are connected or unconnected transformations?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?