what are the challenge face in u r project?explain me
Answer / nitin
Anyway you will see the below issues in general
1. some specific characters are not loading as in the source
2. Data truncation happened on few fields
3. Frequent changes are coming from the user
4. Performance issues when loading huge data
generally we r facing following problems....
Data types mismatch
missing links(source and target column links)
environmental issues(some times source system does not exitst
then we can't read the data from the sources and some times
target system does not exist then we can't load the data
into the target then we have to send a mail to the network
peoples)
| Is This Answer Correct ? | 0 Yes | 0 No |
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
what is parameter file?
what is the method of error handling when session is running?
Explain dynamic target flat file name generation in informatica
what is the Default Source Option For Update Strategy Transformation?
What is joiner transformation in informatica?
How to load last n records of file into target table - informatica
What are the different types of code pages available in informatica & how to implement it in your project?
What are session parameters ? How do you set them?
what is bridge tables in informatica
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?