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 are the steps involved in the migration from older version to newer version of Informatica Server?

1574


How to start a workflow using pmcmd command?

707


What is the use of an aggregator cache file?

683


What are the different components of powercenter?

578


How to partition the Session?

641






Define pmcmd command?

618


What are the tasks that can be performed using sq?

609


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1469


What is difference between a gateway node and worker node?

619


Informatica settings are available in which file?

585


Explain the different kinds of facts.

560


Differences between version 7.x and 8.x.

1415


What is the need for an etl tool?

631


Differentiate between Load Manager and DTM?

1661


Target increases every day even though no new record was inserted

1103