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 enterprise data warehousing?
what are testing in a mapping level please give brif eplanation
Can you start a batches with in a batch?
What are the various types of transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
how to remove staging area
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
How are parameters defined in informatica?
Explain transaction control transformation in informatica