In target table how to display the system time
Answer / murali
Add extr output port in expr trans for using sysdate
function.
Thanks,
Murali
Is This Answer Correct ? | 7 Yes | 0 No |
What is meant by a domain?
What is the commit type if you have a transaction control transformation in the mapping?
What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?
What is limitations of truncate and load option
what is the look up transformation?
What are the ETL tools available in DWH?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
Can we insert ,update ,delete in target tables with one update strategy tran.?
What are the tuning techniques you applied during your last project
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance