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 |
tell me the push down optimization
How do you load first and last records into target table?
Can informatica load heterogeneous targets from heterogeneous sources?
What happens if the info. Server doesn't find the session parameter in the parameter file?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
When the informatica server marks that a batch is failed?
How to open an older version of an object in the workspace?
Explain the etl program with few examples.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
Can we have a Mapping without a Source Qualifier?
i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?