i have a source which relational.I am trying to populate to
target flat file with one column for daily date which is
sysdate.
I want to populate the sysdate coulmn with DD/MM/YYYY
format.
kindly provide a solution for this..my clear that my target
is flat file.
Answer Posted / prabhas
In expression transformation create one out put port, and
write like: TO_DATE('SYSDATE'.'DD/MM/YYYY').
Connect this port to target.
Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica.
What is the difference between a repository server and a powerhouse?
What is a sequence generator transformation?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What does reusable transformation mean?
What is a rank transform?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Define pmcmd command?
What do you understand by a term domain?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is persistent lookup cache?
Explain what are the different versions of informatica?
What are the types of lookup transformation?