Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
No Answer is Posted For this Question
Be the First to Post Answer
What are the active and passive transforamtions?
sorce is a flatfile only 1st and last row should insert to target how will u do?
What is sq transformation?
what is the main advantage of unconnected lookup
What are the different options available for update strategy?
How to update records in Target, without using Update Strategy?
What is Code Page Compatibility?
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
Is there any model difference between ODS and DWH
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?