Answer / 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.

Answer / raju

Hi All,

We can't load the data from source to target without using
any trasnformation, once you drag the source structure into
designer, the sorce structure will come along with source
qualifier t/r.

So, i cant possible to load the data from source to target
withoust using any transformation

Answer / vijay vajja

We can't load the data from source to target without using
any trasnformation.

becoz we are geting SQ trans along with source.
and if we are useing cobal source then we have to use
Normalizer trans.

so it's not posibule to load data from source to target
that with out a transformation.

Answer / srinivasarao dasari

But Source qualifier is also a transformation.

Answer / sunil

we cant load the data from source to target with out using
any transformation

Answer / dilip

write a SQL script like, insert into target_1 (select * from
source_1) and run it in the pre/post source/target load.

Answer / madhavan eyunni

Hi dilip,

Can you explain me in brief..


Madhavan eyunni

Answer / satya

Guys,

I totally agree with HJ, seriously folks dont get panic
with the interviewer, as long as ur correct and you are
confidant and if u r not quit. your job will find u

All the best

Answer / suri

it is not possible to load data form source to target with
out using transformation the reason is while loading the
data from source to targets there will be definitely
modifications in changing the data for example to calculate
the rank of the table like that.... simply the interviewer
will twist us . how we r confident in the subject .....

Answer / amedela chandra sekhar

simply say not possible in informatica u can ask to
interviewer can u plz tell me the answer

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

Where should yoU place the flat file to import the flat file defintion to the designer?

4 Answers  

What is meant by lookup transformation?

0 Answers  

Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

0 Answers  

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

when we dont use aggregator in mapping ?

2 Answers   CSC,

What do you understand by a term domain?

0 Answers  

How do you load only null records into target?

0 Answers  

how can we use sorter transformation in joins?

5 Answers   IBM,