In target table how to display the system time



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

Post New Answer

More Informatica Interview Questions

What is meant by a domain?

0 Answers  


What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,


What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,


What is limitations of truncate and load option

1 Answers   Cap Gemini,


what is the look up transformation?

2 Answers   Informatica,






What are the ETL tools available in DWH?

6 Answers   Mphasis,


wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,


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

1 Answers   TCS,


Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,


What are the tuning techniques you applied during your last project

0 Answers  


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

2 Answers   KPIT,


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

0 Answers   CTS,


Categories