Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7022 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 |
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help
I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out
what is datamart
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
Could you explain what is enterprise data warehouse?
What is operational data source (ODS)?
Router T/R is active but some people are saying it is also passive which is exactly right?
who is the best faculty for informatica in hyderabad ameerpet?
in my source table i want to delete first and last records and load in between records into target? how can it possible?
3 Answers HCL, Thomson Reuters,
Where can we find the throughput option in informatica?
Teradata 
