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
- 7348 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
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what is the difference between cardinality and Nullability?
how do u set partition points in the mapping?
Explain about hash partitioning?
When do we analyze the tables?
What are materialized views & where do we use them?
Define slowly changing dimensions (SCD)?
Do we need an ETL tool? When do we go for the tools in the market?
what is data modeling?
what is session partitioning?
how do u handle performance issues in Informatica . where can u monitor the performance ?
Do we need an etl tool?
List few etl bugs?
Explain do we need an etl tool?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
