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
- 15 Answers
- 31211 Views
- Deloitte, I also Faced
- E-Mail Answers
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 |
Is it possible to have "5 source & 5 Target" in single mapping?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
server hot-ws270 is connect to Repository B. What does it mean?
what is fact and what types of fact tables is there
How to extract the informatica rejected data?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
How to compare Source and Target table, without using dynamic lookup?
can we see default group,when we use router?if yes how?
What is CDC? How to implement CDC?
I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
when we use dynamic lookup,if condition matches what will be the o/p?
Teradata 
