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
how to create user defined function (udf) in informatica
What do mean by local and global repository?
What are the different components of powercenter?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain the informatica workflow?
What does role playing dimension mean?
What do you mean incremental aggregation?
can we override a native sql query within informatica? Where do we do it?
How can we delete duplicate rows from flat files?
How to convert multiple rows to single row (multiple columns) in informatica
Scheduling properties,whats the default (sequential)
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
How an expression transformation differs from aggregator transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
How many number of sessions can one group in batches?