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

how to create user defined function (udf) in informatica

1031


What do mean by local and global repository?

932


What are the different components of powercenter?

810


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

895


Explain the informatica workflow?

822


What does role playing dimension mean?

816


What do you mean incremental aggregation?

824


can we override a native sql query within informatica? Where do we do it?

875


How can we delete duplicate rows from flat files?

972


How to convert multiple rows to single row (multiple columns) in informatica

1136


Scheduling properties,whats the default (sequential)

1687


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1870


How an expression transformation differs from aggregator transformation?

836


Describe the impact of several join conditions and join order in a joiner transformation?

834


How many number of sessions can one group in batches?

909