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 |
What is active and passive transformation?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
how to sort date field in infomatica?
When do you use sql override in a lookup transformation?
What is sql query override? When did u use sql query override?
with out using update strategy transnsformation how to update the data in mapping level
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
What is performance tuning in informatica. What measures you will take if some thing is taking much time in your process of ETL?
What is meant by LDAP users?
What are the limitations of joiner transformation?
What are the uses of a Parameter file?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation