Answer Posted / venugopal
When the reference data is more and source data is very
very less at that time we are using the Sparce lookup i.e
the ratio is 1:100
| Is This Answer Correct ? | 23 Yes | 5 No |
Post New Answer View All Answers
Explain how a source file is populated?
Can you highlight the main features of ibm infosphere information server?
What is the purpose of pivot stage?
Can you explain link buffering?
Can you implement SCD2 using join, transformer and funnel stage?
What is the difference between passive stage and active stage?
What all the types of jobs you developed?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What are routines in datastage? Enlist various types of routines.
how to sort two columns in single job in datastage.
What is a folder? Difference types of stages?
Can you explain kafka connector?
what is use of SDR function?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?