Interested to Buy Any Domain ? << Click Here >> for more details...
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000.
but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
- 0 Answers
- 2947 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
why we are using level option in normalizer transformation
What is operational data source (ODS)?
When will you use SQL override in a lookup transformation?
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
what is procedure to use mapping variable in source qualifier transformation? with example
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
How will the document be delivered to me?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
What is lookup change?
Teradata 
