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 |
what are the transformations that restricts the partitioning of sessions?
Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga
Whats the difference between informatica powercenter server, repositoryserver and repository?
what is the -ve test case in your project.
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
How to extract sap data using informatica?
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is an expression transformation in informatica?
how to get the only updated records in the target
What is the difference between Power Centre and Power Mart?