What are the issues u have faced in ur project?
Guys pls answer to dis question.Due to this question I have
failed in 3 interviews.
Answers were Sorted based on User's Feedback
Answer / jeevan kumar
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 ? | 27 Yes | 2 No |
Answer / ca sreedhar nukala
Well, I agree with the answers quoted by our friends Geevan
and Rajesh. However, one has to be clear that as far as
this type of questions are being asked in any interview, by
and large we must understand that you must have shown in
your curriculum that you have project experience. Now, the
question is what type of projects you have done. your
answer should reflect that you have the original experience
and not the fake. If you really have such experience then
it would be childish play to answer this question. If not
you have to meet the real experienced people of such
projects, remeber this such projects means the same
projects, what you have claimed in your biodata. Whatever,
the problems you have faced (every project will have some
problems/issues depending upon the nature of the project.)
Is it Software Project, Networking Project, Cinema Project,
construction Project.... Your answer should show the
problems faced by you during the course of carring on the
project.
| Is This Answer Correct ? | 9 Yes | 8 No |
Answer / rajesh manepalli
Generally some one ask this question i will answer to
question in such a manner if we want to complete a project
successful we must require first and foremost that is Team
support from our Team members every one should be in the
same path in the team other wise we should definitely face a
problem in this circumstance please share your thought if i
am wrong.....................
| Is This Answer Correct ? | 2 Yes | 22 No |
how to join the two flatfiles using the joiner t/r if there is no matching port?
What are the steps involved in the migration from older version to newer version of Informatica Server?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is a surrogate key?Why we use it in a mapping?Pl give an example.
what is Active lock explain
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the sequence generator transformation in informatica?
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
how much memory (size) occupied by a session at runtime
State the differences between sql override and lookup override?