Without using any transformations how u can load the data into
target?

Answer Posted / hj

if i were the candidate i would simply say if there are no
transformations to be done, i will simply run an insert
script if the source and target can talk to each other. or
simply source -> source qualifier -> target. if the
interviewer says SQ is a transformation, then say "then i
dont know. i have always used informatica when there is
some kind of transformation involved because that is what
informatica is mainly used for". that will shut him up. :)
trust me, you wont lose the interview for just this
question. personally, whoever asks this qestion is not
there in the interview process to find a good candidate for
the post, he is just there to have some fun torturing
candidates. dont panic. as long as you know answers to
genuine informatica questions and know your business area,
there is always a job waiting for u.

Is This Answer Correct ?    23 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an aggregator transformation?

859


Explain the code page compatibility?

866


What are the components of workflow manager?

829


What is informatica metadata and where is it stored?

788


I have a flat file, want to reverse the contents of the flat file

930


What is the difference between source qualifier transformations source filter to filter transformation?

869


What is the difference between informatica 7.0 and 8.0?

775


In informatics server which files are created during the session rums?

890


How can we use mapping variables in informatica?

824


What are the popular informatica products?

824


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

814


How to create or import flat file definition in to the warehouse designer?

897


What are the types of presistent cache in look up tr.

1843


what is the hint? how to use it to reduce the query processing in program?

7188


what is the -ve test case in your project.

2143