Interested to Buy Any Domain ? << Click Here >> for more details...
Without using any transformations how u can load the data into
target?
- 15 Answers
- 24701 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 23 Yes | 0 No |
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
| Is This Answer Correct ? | 13 Yes | 2 No |
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.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / srinivasarao dasari
But Source qualifier is also a transformation.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / sunil
we cant load the data from source to target with out using
any transformation
| Is This Answer Correct ? | 4 Yes | 1 No |
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.
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / madhavan eyunni
Hi dilip,
Can you explain me in brief..
Madhavan eyunni
| Is This Answer Correct ? | 0 Yes | 0 No |
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
| Is This Answer Correct ? | 0 Yes | 0 No |
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 .....
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / amedela chandra sekhar
simply say not possible in informatica u can ask to
interviewer can u plz tell me the answer
| Is This Answer Correct ? | 0 Yes | 0 No |
how to insert header after each group.
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?
how can we check whether a particular cache is static or dynamic?
Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?
Mention few power centre client applications with their basic purpose?
why do u use shortcuts in informatica.?
On which transformations you created partitions in your project?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
How to create a non-reusable instance of reusable transformations?
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
Teradata 
