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
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
What is the difference between round-robin partitioning and hash partitioning?
Explain etl mapping sheets?
What are the steps involved in etl process?
what make u disappointmnets in u r career
how many steps are there in etl process?
What are the different Lookup methods used in Informatica?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
Explain about round-robi?
what is Forward,Reverse and Re_engineering?
What are three tier systems in etl?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
flat filevalidation in informatica
Explain about power designer data modeling software?
how does the server recongnise the source and target databases.Elaborate on this
explain the methodology of Data Warehousing?(Polaries)