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
Answers were Sorted based on User's Feedback
Answer / santoshi
The main data object present inbetween source and target is
staging layer only, Staging layer will do eliminate the
inconsistency data and gives the result data object
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / rajupatel
Data Object: intermediate table if we r using or Stage
table (temp table) which are the resulting data object
after applying the transformation.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / anupama
source qualifier is the correct answer,because with out
source qualifier u cant do any thing
Is This Answer Correct ? | 2 Yes | 1 No |
Answer / manohar
Answer is Source Qualifier.
Since the source may be anything so Informatica should be
able to understand the data types perfectly, so only the
data can be pass through to the target. So you can see when
drag the souce along with the source SQ will be created
automatically.
why not the other transformations?
Since other transformations are not capable of wat the SQ
transformation has.
Correct me if i am wrong
Is This Answer Correct ? | 5 Yes | 4 No |
Answer / bsgsr
hi,
i believe ods cant b called a data object. its a temp
database for validating the data n applying business logic
on that.
it shud me a transformation. probably the ans kud be
repository object since transformation is a reposiyory
object.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / pratibha
Links may be..Between source and target, there are links that are joining ports.
Is This Answer Correct ? | 0 Yes | 0 No |
How does the aggregator transformation handle null values?
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
What is partioning?how many types of partinings are there
Discuss the advantages & Disadvantages of star & snowflake schema?
In update strategy target table or flat file which gives more performance ? why?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
Howmany ways yoU can update a relational source defintion and what are they?
what is the difference between copy object import objects using repositery manager which one is best
What is sql query override? When did u use sql query override?
Name the different lookup cache(s)?
why we r using presql&postsql in source qualifier?