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
What are the steps involved in the migration from older version to newer version of Informatica Server?
How to start a workflow using pmcmd command?
What is the use of an aggregator cache file?
What are the different components of powercenter?
How to partition the Session?
Define pmcmd command?
What are the tasks that can be performed using sq?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is difference between a gateway node and worker node?
Informatica settings are available in which file?
Explain the different kinds of facts.
Differences between version 7.x and 8.x.
What is the need for an etl tool?
Differentiate between Load Manager and DTM?
Target increases every day even though no new record was inserted