Interested to Buy Any Domain ? << Click Here >> for more details...
Hello all,
Source Table(Flat File):- Target Table(Flat File):-
Date Date
01/08/2008(DD/MM/YYYY) 01/08/2008
02/08/2008
03/08/2008
04/08/2008
05/05/2008
My requiremnt is this. I need to do it by informatica,Plz
tell me how can i do it?
Thanks
- 3 Answers
- 7081 Views
- I also Faced
- E-Mail Answers
Answer Posted / kal
The simplest thing U can do is
while importing the source flatfile using "Flat File Import
Wizard"
In Step1 choose-> FixedWidth
in the step2 -> click and create a column or tab on the
field then U can import them as 2 fields
1. 01/08/2008
2.(DD/MM/YYYY)
U can ignore the second column and use the first one.
second method is by taking only the date value in
Expression Transformation.
Hope this of any help
Kal
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to fine tune mappings?
what is the difference between cubes and package in cognos
List few etl bugs?
What are the names of the layers in etl?
How etl testing is different from database testing?
what are the data modeling tools you have used?(polaris)
What is fact? What are the types of facts?
what are Lookup caches options? Including persistent caches.
what is the use of server?
What are the three tiers in etl?
what is the main role of FI on business
Explain about power designer data modeling software?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
Explain do we need an etl tool?
what is different between sequential batch and concurrent batch and which is recommended and why?
