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

What do you mean by filter transformation?

0 Answers  

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

generate Unique sequence numbers for each partition in session with Unconnected Lookup ? Hi All, Please help me to resolve the below issue while Applying partitioning concept to my Session. This is a very simple mapping with Source, Lookup , router, and target. I need to Lookup on the target and compare with the source data, if any piece of data is new then Insert, and If any thing change in the existed data then Update. while Inserting the new records to the target table I'm generating sequence numbers with Unconnected lookup, by calling the maximum PK ID from the target table. The above flow is working fine from last one year. Now I wish to apply the Partitioning concept to the above floe(session) At source I used 4 pass through partitions.(For Each partition different filter conditions to pull the data from source) at Target I used 4 passthrough Partitions. it is working fine for some data, but for some rows for Insert Operation , it is throwing Unique key errors, because while Inserting the data it is generating the same sequence key twice. In detail : 1st row is coming from 1st partition and generated the sequence number 1 for that row. 2nd row is coming from 1st partition and generated the sequence number 2 for that row 3rd row is coming from the 2nd partition generated the sequence number 2 again for that row. (it must generate 3 for this row) the issue is becuase of generating the same sequence numbers twice for different partitions. Can any one Please help me to resolve this issue. While Applying partitions how can I generate a Unique Sequence numbers from Unconnected lookup for Each partitioned data. Regrads, N Kiran.

2 Answers   Tech Mahindra,

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers   IBM,

How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

what is the location of parameter file in informatica?

1 Answers   TCS,

what is the monster dimension plz give me one example

2 Answers   EDS,

How to display null values on a target & non-null values on a target?

3 Answers