Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 6914 Views
- I also Faced
- E-Mail Answers
Answer Posted / ramana
we need two pipelines in mapping.In first pipeline,take expression trans,create one port with date type and assign sysdate to it.After drag this port to target file.
In the second pipeline load the source record into target file.But here we need to select APPEND IF EXISTS option.Both pipelines we need to give same file name.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is meant by query override?
What is data movement mode in Informatica and difference between them?
what is index?how it can work in informatica
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How can we handle two sessions in informatica?
What are active transformations.
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
Differentiate between joiner and lookup transformation?
What are the different types of transformation available in informatica.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What is the reusable transformation?
How to elaborate tracing level?
How big was your fact table
4 yrs etl devloper roles and responsibilities?any body give solutions
