what are the challenge face in u r project?explain me
Answer Posted / 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 |
Post New Answer View All Answers
what is Active lock explain
Separate from an archive server and a powerhouse?
What is the benefit of session partitioning?
Explain about cumulative Sum or moving sum?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Differentiate between router and filter transformation?
Why do you use Mapping Parameter and mapping variable?
How to join three sources using joiner? Explain though mapping flow.
Explain the features of connected and unconnected lookup.
What do you mean by blocking transformation?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is an Integration service in Informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.