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 / bsgsr
hi, anju,
gud thinking.
r u trying for a break with the industry or currently
working on that.would you wind sending a mail to me on my
id bsgsr12@gmail.com for knowledge transfer.
bye.
bsgsr
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / 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 |
Answer / prakash.s
It may be ETL Tools like Informatica,Datastage,etc.,
| Is This Answer Correct ? | 0 Yes | 1 No |
how can we use sorter transformation in joins?
Explain incremental aggregation in informatica
Explain scd type 3 through mapping.
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
Using Expression transformation how to remove duplicate records from a relational source?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
What is the main difference between a Joiner Transformation and Union Transformation?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
what is the mechanism of the Master-Detail joining condition?
What are the challenges of Dataware housing in the future?