What is the main data object present inbetween source and
target. I answered Mapping. Transformation etc.. But it is
not the answer. So please give me an apt answer. Thanks in
advance
Answer Posted / sanat @ tcs
why it could not be Expression, and any other
transformation, Even SQ is almost like as Source, that is
already in question, obviously u can do SQL Override but
still an confusing answer as SQ. can u pls tell me why SQ
and why not any other transformations..???
Thanks
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How do you change a non-reusable transformation to reusable transformation?
what is index?how it can work in informatica
Explain informatica architecture - version 8 / 9
What is a filter transformation and why it is an active one?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
define galaxy repository in informatica
What are the restrictions of union transformation?
explain abt ur project architecture?
How do you load unique records into one target table and duplicate records into a different target table?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What do you mean by blocking transformation?
As union transformation gives UNION ALL output, how you will get the UNION output?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks