If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING..
CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE
RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?
- 1 Answers
- 6686 Views
- TCS, I also Faced
- E-Mail Answers
Answer / babu
yes, u can see the out put in single run,
in mappings tab one option is there, that is TARGET LOAD
ORDER.
if any thing is wrong please let me know.
Cheers,
babu
| Is This Answer Correct ? | 5 Yes | 0 No |
can v update d records in target using update stargey without generationg primary key ? explain
How to load relational source into file target?
I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?
explain abt union t/r?
What is rank index in rank transformation?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
plz plz plz send client names and project names in informatica?
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
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.
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
can a port in expression transf be given the name DISTINCT
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
Teradata 
