what are the challenge face in u r project?explain me



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

Post New Answer

More Informatica Interview Questions

Issue with Update override at Target table in Informatica.

2 Answers  


How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,


Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   Accenture, HCL,


What is incremental aggregation?

0 Answers  


I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,






Which will beter perform IIf or decode?

3 Answers   TCS,


how much memory (size) occupied by a session at runtime

4 Answers   Wipro,


What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  


hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,


What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,


Explain where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  


wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,


Categories