Answer Posted / sai suresh
Connected lookup is participats in Mapping level and it
will takes multipul inputs and provides multipul outputs.\
Unconnected lookup is does't participats in Mapping level
and it will takes multipul inputs and provied single output
only
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
According to his methodology what all you need before you build a datawarehouse
In how many ways we can create ports?
What is a sequence generator transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
What are the transformations that are not supported in mapplet?
what is the size of your data warehousing?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is sq transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Write the program through which the records can be updated?
my source is junk data how will u remove that junk data by using unix please any one replay me
tell me about your project functionality