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
How we can create indexes after completing the load process?
How to handle decimal places while importing a flatfile into informatica?
What does “tail –f” command do and what is its use as an Informatica admin.
What is primary and backup node?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What do think which one is the better joiner or look up?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is a standalone command task?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the Rank index port in Rank transformation?
How to improve the performance of a session using sorter transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
can u any challenge your project?