What are the basic requirements to join two sources in a source qualifier transformation using default join?
No Answer is Posted For this Question
Be the First to Post Answer
How can u stop a batch?
What is the difference between Active and Passive transformation?
how do u tune queries?
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How
In session log thier should not be a single error how will u do
how do u fnd the duplicate rows and how to delete the duplicate rows?
what is DSS?
What is the need of an ETL tool?