WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER?
chandumba2005@gmai.com
Answers were Sorted based on User's Feedback
Answer / srinivasulu raju
It is a Process of Defining the User Defined SQL Query: "to
filter the data,Join the Data, Sorting the data,
eliminating Duplicates...
Condition: Source must be DataBase.
Is This Answer Correct ? | 5 Yes | 0 No |
hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Which is costliest transformation? costly means occupying more memory?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.
what is unique constraint error ?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
where is the reject loader .
What are the different threads in DTM process?
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com
Explain in detail scd type 2 through mapping.
In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query